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