TODAY
Returns the current date, with no time part.
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
- A calculated column that uses TODAY is calculated at refresh time. A measure that uses TODAY is recalculated each time a visual is drawn. The two can show different dates.
- For a month-end pack that must not change later, use a fixed report date parameter instead of TODAY.
- TODAY uses the clock of the server or service that runs the model, which may not match your local time zone around midnight.
- TODAY is not a business date. A bank holiday or a close date is still a calendar date to TODAY.
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.