# DATE Function (DAX)

Returns the specified date in **datetime** format.

DATE(<year>, <month>, <day>)

Term | Definition | ||
---|---|---|---|

| A number representing the year. The value of the Dates beginning with March 1, 1900 are supported. If you enter a number that has decimal places, the number is rounded. For values greater than 9999 or less than zero (negative values), the function returns a If the
| ||

| A number representing the month or a calculation according to the following rules: If If you enter an integer larger than 12, the following computation occurs: the date is calculated by adding the value of If you enter a negative integer, the following computation occurs: the date is calculated subtracting the value of | ||

| A number representing the day or a calculation according to the following rules: If If you enter an integer larger than last day of the given month, the following computation occurs: the date is calculated by adding the value of If you enter a negative integer, the following computation occurs: the date is calculated subtracting the value of If |

Returns the specified date (**datetime)**.

The DATE function takes the integers that are input as arguments, and generates the corresponding date. The DATE function is most useful in situations where the year, month, and day are supplied by formulas. For example, the underlying data might contain dates in a format that is not recognized as a date, such as YYYYMMDD. You can use the DATE function in conjunction with other functions to convert the dates to a number that can be recognized as a date.

In contrast to Microsoft Excel, which stores dates as a serial number, DAX date functions always return a **datetime** data type. However, you can use formatting to display dates as serial numbers if you want.

This DAX function may return different results when used in a model that is deployed and then queried in DirectQuery mode. For more information about semantic differences in DirectQuery mode, see http://go.microsoft.com/fwlink/?LinkId=219171.

The following formula returns the date July 8, 2009:

=DATE(2009,7,8)

If the value that you enter for the **year** argument is between 0 (zero) and 1899 (inclusive), that value is added to 1900 to calculate the year. The following formula returns January 2, 1908: (1900+08).

=DATE(08,1,2)

If the value that you enter for the **year** argument is between 0 (zero) and 1899 (inclusive), that value is added to 1900 to calculate the year. The following formula returns January 2, 3700: (1900+1800).

=DATE(1800,1,2)

If **year** is between 1900 and 9999 (inclusive), that value is used as the year. The following formula returns January 2, 2008:

=DATE(2008,1,2)

If **month** is greater than 12, **month** adds that number of months to the first month in the year specified. The following formula returns the date February 2, 2009:

=DATE(2008,14,2)

If the **month** value is less than 1, the DATE function subtracts the magnitude of that number of months, plus 1, from the first month in the year specified. The following formula returns September 2, 2007:

=DATE(2008,-3,2)

If **day** is greater than the number of days in the month specified, **day** adds that number of days to the first day in the month. The following formula returns the date February 4, 2008:

=DATE(2008,1,35)

If **day** is less than 1, **day** subtracts the magnitude that number of days, plus one, from the first day of the month specified. The following formula returns December 16, 2007:

=DATE(2008,1,-15)