DATE DAX Function (Date and Time)
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:
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/date-function-dax