Skip to main content
Version: I2025.4.x

YearEndDate

Given the input date, returns a date representing the last day of the Gregorian calendar year.

Syntax​

YearEndDate(Date)

Parameters​

Date
The date to return the year end date for.

Example​

The following expression returns the last day of the year in which 2007-06-09 occurred:

[DateCustom].[Retail445].[Reporting Day].&[YearEndDate("2007-06-09T10:30:12")]]