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

Day

Returns an integer (1-31) representing the day of the month on which the specified date occurs.

Syntax

Day(Date)

Parameters

Date
The date to return the day for.

Example

The following example returns the day of the month on which 2007-07-05 occurred:

[DateCustom].[DateInt].[DayInt].&[Year("2007-07-05T12:30:10")]&[Month("2007-07-05T12:30:10")]&[Day("2007-07-05T12:30:10")]