Downloads
DAXDate and timeBeginner

DATE

Returns a date built from a year, a month number and a day number.

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

Returns: A date (a datetime value with no time part).

What it does

DATE builds a real date from three numbers. Finance models use it for fixed reporting dates such as a fiscal year end, a quarter cut-off or the date of a month-end pack. It also turns separate year, month and day columns from an older export into one date. Writing a date as DATE(2026, 6, 30) is safer than writing it as text, because text dates such as 6/30/2026 can be read differently on different computers.

Syntax and arguments

Example

A company has a June 30 year end. The controller wants a measure that shows the fiscal year end date for whatever month is in the report.

FY End Date =
VAR CurrentYear = YEAR(MAX('Calendar'[Date]))
VAR FYEnd = DATE(CurrentYear, 6, 30)
RETURN
IF(MAX('Calendar'[Date]) > FYEnd, DATE(CurrentYear + 1, 6, 30), FYEnd)

For a date in October 2026, the measure returns June 30, 2027, the end of the fiscal year that started on July 1, 2026. For a date in March 2026, it returns June 30, 2026. DATE builds the two candidate dates and the IF picks the right one.

Example: a second, different use

A bank export splits the posting date into three numeric columns. In a calculated column on the ledger table, DATE joins them into one date that can be related to the Calendar table.

Posting Date =
DATE(
    'GL_Entries'[PostYear],
    'GL_Entries'[PostMonth],
    'GL_Entries'[PostDay]
)

Things to watch

In business terms

Finance teams use DATE to set fixed period boundaries: fiscal year start and end, quarter cut-offs, and the reporting date for a close pack. Getting these boundary dates right is the first check in any month-end, budget or audit date review.

Related functions

All DAX functions · View as Markdown · DAX fundamentals