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

PrevQuarterStartDate

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

Syntax

PrevQuarterStartDate(Date)

Parameters

Date
The date to return the previous quarter start date for.

Examples

The following expression returns the first day of the quarter before 2006-03-12 occurred:

[DateCustom].[StandardMonth].[Quarter].&[`PrevQuarterStartDate("2006-03-12T12:30:10")`]