Skip to main content
Version: Next

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