DATE

Description:

This functions returns the formatted date value of the given date.

Syntax:

Date(Scalar_Expression)

Return Type:
SCALAR

Parameters:

Parameter	Description

Parameter	Description
Scalar_Expression	A valid MDX Expression which returns a scalar value of date datatype.

Example:

WITH 
MEMBER [Measures].[Target Date Sales] AS
(
    [Measures].[Internet Sales Amount],
    [Date].[Calendar].[Date].&[2007]&[1]&[1]&[February]&[2007-02-01 00:00:00.0]
)

SELECT 
    [Measures].[Target Date Sales] ON COLUMNS
FROM [AdventureWorksMF_ValueBased]