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