Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
TODAY
Applies to: 👁 Image
Calculated column 👁 Image
Calculated table 👁 Image
Measure 👁 Image
Visual calculation
Returns the current date.
Syntax
TODAY()
Return value
A date (datetime).
Remarks
The TODAY function is useful when you need to have the current date displayed in a report, regardless of when you open it. It is also useful for calculating intervals.
If the TODAY function does not update the date when you expect it to, you might need to change the settings that control when the report or semantic model is refreshed.
The NOW function is similar but returns the exact time, whereas TODAY returns the time value 12:00:00 AM (midnight) for all dates.
Example
If you know that someone was born in 1963, you might use the following formula to find that person's age as of this year's birthday:
= YEAR(TODAY())-1963
This formula uses the TODAY function as an argument for the YEAR function to obtain the current year, and then subtracts 1963, returning the person's age.
Related content
Feedback
Was this page helpful?