DATE DAX Function (Date and Time)

Syntax  |  Return values  |  Related  

Returns the specified date in datetime format.

Syntax

DATE ( <Year>, <Month>, <Day> )

Parameter	Attributes	Description
Year		A four digit number representing the year.
Month		A number from 1 to 12 representing the month of the year.
Day		A number from 1 to 31 representing the day of the month.

Return values

Scalar A single datetime value.

Returns the specified date.

Related functions

Other related functions are:

• TIME

Last update: Jan 23, 2021   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/date-function-dax