GETDATE

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 return the formated date value for the provided date value.

Syntax:

GETDATE(Scalar_Expression)

Return Type:

SCALAR_EXPRESSION

Parameters:

Parameter	Description

Parameter	Description
Scalar_Expression	A date scalar value which is a date datatype type.

Example:

WITH MEMBER [Measures].[Today] AS
    GetDate()
SELECT 
    {[Measures].[Internet Sales Amount], [Measures].[Today]} ON COLUMNS
FROM [AdventureWorksMF_ValueBased]