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].[Today] AS
    GetDate()
SELECT 
    {[Measures].[Internet Sales Amount], [Measures].[Today]} ON COLUMNS
FROM [AdventureWorksMF_ValueBased]