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

Year

Given the input date, returns an integer (0-9999) representing the year.

Syntax

Year(Date)

Parameters

Date
The date to return the year for.

Example

The following example returns the year for 2005-10-08:

[DateCustom].[DateInt].[YearInt].&[`Year("2005-10-08T12:30:10")`]