Downloads
DAXDate and timeBeginner

TODAY

Returns the current date, with no time part.

Syntax
TODAY()

Returns: A date.

What it does

TODAY returns the date on which the model is evaluated. Finance teams use it to age open items as of the current date, to count days past due, and to show a "data as of" stamp. Because the value changes with the calendar, it is a moving target. A report run in November shows different aging than the same report run in October, which is correct for a live view but wrong for a closed month.

Syntax and arguments

TODAY takes no arguments. Write it with empty parentheses: TODAY().

Example

Open invoices in an aging table should show how many days each one is past due. The due date is in the invoice table, and TODAY supplies the current date.

Days Past Due =
IF(
    'Invoices'[Status] = "Open",
    MAX(0, DATEDIFF('Invoices'[DueDate], TODAY(), DAY))
)

An invoice due on October 1 and viewed on October 29 shows 28 days past due. An invoice not yet due shows 0, because MAX stops the result from going negative. Invoices that are not open return a blank, so they do not affect the total.

Example: a second, different use

A live dashboard can show how many days remain until a tax filing deadline.

Days to Filing Deadline = DATEDIFF(TODAY(), DATE(2027, 3, 15), DAY)

Things to watch

In business terms

TODAY supports live aging reports, collections call lists, due date reminders, the days left to a filing or audit deadline and the "as of" date on operational dashboards. Closed-period reports should use a fixed date instead, so that the numbers stay the same.

Related functions

All DAX functions · View as Markdown · DAX fundamentals