GETDATE

GETDATE

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].[Result] AS GETDATE([Dimensions].[Hierarchy].CURRENTMEMBER.membervalue) SELECT [Measures].[Result] ON 0 FROM [CubeName]

 

Copyright Kyvos, Inc. 2026. All rights reserved.