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

YearStartDate

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

Syntax

YearStartDate(Date)

Parameters

Date
The date to return the year start date for.

Example

The following expression returns the start date of the year in which 2008-06-09 occurred:

[DateCustom].[StandardWeek].[Year].&[`YearStartDate("2008-06-09T10:30:12")`]