Today
The Today function returns the current date based on the UTC time zone.
For more information (including use case exercises) about date functions, see the Common Date Functions and Use Cases QuickStart.
Syntax
Today()
The Today function doesn't reference arguments. You can use it independently to generate the current date, or you can use it within another function to reference the current date.
Examples
Today()
Returns the date (in UTC time) of the moment the function was submitted or the last time the data was refreshed.
DateDiff(“day”, [Invoice Date], Today())
Returns the number of days between the date in the Invoice Date column and the current UTC date (based on the moment the function was submitted or the last time the data was refreshed).
DateAdd(“day”, -1, Today())
Returns the previous day's date relative to the UTC date of the moment the function was submitted or the last time the data was refreshed.