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

QuarterStartDate

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

Syntax

QuarterStartDate(Date)

Parameters

Date
The date to return the quarter start date for.

Examples

The following expression returns the start date of the quarter in which 2007-05-12 occurred:

[DateCustom].[StandardMonth].[Quarter].&[QuarterStartDate("2007-05-12T12:30:10")]