DOCUMENTATIONAPI REFERENCEAI-Link
DownloadsSupport
Loading search results...
Working with CubesCreating CubesModeling Cube MeasuresAdd Calculated MeasuresMDX ReferenceVBA Date FunctionsYearEndDate

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")]]