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

Month

Returns an integer (1-12) representing the month of the year in which the given date occurs.

Syntax

Month(Date)

Parameters

Date
The date to return the month for.

Example

The following example returns the number of the month in which 2006-10-05 occurred:

[DateCustom].[DateInt].[MonthInt].&[`Year("2006-10-05T12:30:10")`]&[`Month("2006-10-05T12:30:10")`]