Returns the current date as of the specified or default timezone.
Sample usage
TODAY()
TODAY("America/Los_Angeles")
TODAY("-08")
Syntax
TODAY([time_zone])
Parameters
time_zone
- Optional. A text field or expression representing the timezone to use. If no timezone is specified, the default timezone UTC is used. See Timezone definitions for information on how to specify a time zone.If the
time_zone
parameter evaluates toNULL
, this function returnsNULL
.
Return data type
Date
Examples
Example formula | Input | Output |
---|---|---|
TODAY() |
January 10, 2020 | 2020-1-10 |
Notes
TODAY
is a synonym for CURRENT_DATE.