FORMAT
Description:
This function formats the given date value to the required format.
Syntax:
Format(Scalar_Expression, String_Expression)
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Scalar_Expression | It is a valid MDX expression that returns a data value to be formatted. |
String_Expression | The format string to apply. |
Example:
WITH MEMBER [Measures].[FormattedValue] AS Format([Date Hierarchy].[Order Date].&[2012-12-31 00:00:00.0].membervalue, "DD-MM-YYYY") SELECT [Measures].[FormattedValue] ON 0 FROM [AdventureWorksMF]