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

MonthStartDate

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

Syntax

MonthStartDate(Date)

Parameters

Date
The date to return the month start date for.

Example

The following example returns the first day of the month in which 2005-08-15 occurred:

[DateCustom].[StandardMonth].[Month].&[`MonthStartDate("2005-08-15T12:30:10")`]