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 |
|---|
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:
| Code Block |
|---|
|
WITH MEMBER [Measures].[X] AS CDATE("1999-02-18") SELECT [Measures].[X] ON 0 FROM [AdventureWorksMF] |
