DATE

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 functions returns the formatted date value of the given date.

Syntax:

Date(Scalar_Expression)

Return Type:
SCALAR

Parameters:

Parameter	Description

Parameter	Description
Scalar_Expression	A valid MDX Expression which returns a scalar value of date datatype.

Example:

WITH 
MEMBER [Measures].[Target Date Sales] AS
(
    [Measures].[Internet Sales Amount],
    [Date].[Calendar].[Date].&[2007]&[1]&[1]&[February]&[2007-02-01 00:00:00.0]
)

SELECT 
    [Measures].[Target Date Sales] ON COLUMNS
FROM [AdventureWorksMF_ValueBased]