Versions Compared

Version Old Version 1 New Version Current
Changes made by

Sarabjeet Kaur

Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

Code Block
languagejava
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]