Skip to main content

QuarterEndDate

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

Syntax

QuarterEndDate(Date)

Parameters

Date
The date to return the quarter end date for.

Example

The following expression returns the last day of the quarter in which 2006-07-01 occurred:

[DateCustom].[Retail445].[Reporting Day].&[`QuarterEndDate("2006-07-01T15:30:12")`]