MONTH
Description:
This function returns month part of the given date.
Syntax:
MONTH(Scalar_Expression)
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Scalar_Expression | A valid MDX Expression which returns a scalar value of date datatype. |
Example:
WITH MEMBER [Measures].[CurrentMonth] AS Month([Date Hierarchy].[Order Date].&[2012-12-31 00:00:00.0].membervalue) SELECT [Measures].[CurrentDate] ON 0 FROM [AdventureWorksMF]