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

MonthEndDate

Returns a date representing the last day of the Gregorian calendar month in which the input date occurs.

Syntax

MonthEndDate(Date)

Parameters

Date
The date to to return the month end date for.

Example

The following example returns the last day of the month in which 2008-04-10 occurred:

[DateCustom].[Retail445].[Reporting Day].&[`MonthEndDate("2008-04-10T15:30:12")`]