CDATE

This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here.

This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here.

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]