CDATE

Description:

This function is used to convert the specified string expression into a date value.

Syntax:

CDATE(String_Expression)

Return Type:
SCALAR

Parameters:

Parameter	Description

Parameter

Description

String_Expression

It is a valid MDX expression that returns a string scalar value.
Supported date formats are:
"yyyy-MM-dd'T'HH:mm:ss'Z'", "yyyy-MM-dd'T'HH:mm:ssZ", "yyyy-MM-dd'T'HH:mm:ss", "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'", "yyyy-MM-dd'T'HH:mm:ss.SSSZ", "yyyy-MM-dd HH:mm:ss", "MM/dd/yyyy HH:mm:ss", "MM/dd/yyyy'T'HH:mm:ss.SSS'Z'", "MM/dd/yyyy'T'HH:mm:ss.SSSZ", "MM/dd/yyyy'T'HH:mm:ss.SSS", "MM/dd/yyyy'T'HH:mm:ssZ", "MM/dd/yyyy'T'HH:mm:ss", "yyyy:MM:dd HH:mm:ss","yyyy-MM-dd", "yyyy/MM/dd", "MM/dd/yyyy", "yyyy:MM:dd", "yyyyMMdd", "yyyy-MMM-dd", "yyyy/MMM/dd"

Example:

WITH MEMBER [Measures].[Date Value] AS
CDate([Date].[Calendar].CurrentMember.Name)
SELECT 
[Measures].[Date Value] ON COLUMNS,
[Date].[Calendar].[Month].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]