DATE
Description:
This functions returns the formatted date value of the given date.
Syntax:
Date(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].[CurrentDate] AS Date([Date Hierarchy].[Order Date].&[2012-12-31 00:00:00.0].membervalue) SELECT [Measures].[CurrentDate] ON 0 FROM [AdventureWorksMF]