/
CDATE

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

Related content

DATE
More like this
Date and Time Format Codes
Date and Time Format Codes
More like this
Date and Time Format Codes
Date and Time Format Codes
More like this
Date and Time Format Codes
Date and Time Format Codes
More like this
Date and Time Format Codes
Date and Time Format Codes
More like this

Copyright Kyvos, Inc. All rights reserved.