Returns the current date (
(TODAY() - 1) returns yesterday's date.
(TODAY() + 1) returns tomorrow's date.
(TODAY() + 7) returns the date one week from today.
(TODAY() - WEEKDAY(TODAY())) returns the date of Saturday of last week. See also:
(TODAY() - WEEKDAY(TODAY()) + 4) returns the date of Wednesday of this week.
The values returned by
TIMENOW() reflect the timezone offset of the user's device. For example, if the timezone of the user's device is Pacific Standard Time (PST), the value returned is UTC-08:00; if the timezone of the user's device is Hong Kong, the value returned is UTC+8:00.
When the user's device contacts the server to read or update data, the device includes its timezone with the request. The server uses the timezone of the user's device when performing time and date calculations. For example, when the server evaluates security filters and workflow rules that include dates and times.