EndOfYear

Summary

The EndOfYear function returns the last day and time value for the given year.

Syntax

EndOfYear([date|date_time|instant|offset_date_time|zoned_date_time])

Return Type

Offset_date_time

Details

The function accepts an optional date or date time input parameter. The function returns the the final offset_date_time value for the given year found in the input parameter value. If no input parameter is provided, Connect uses the current local date (Pacific Time).

Examples

eval EndOfYear();

screen-shot-2016-09-12-at-8-25-13-am

 

eval EndOfYear(‘1977-04-01’);

screen-shot-2016-09-12-at-8-25-20-am

 

Related Functions

EndOfMonth

StartOfMonth

StartOfYear