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

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