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