TODAY

Returns the current date according to 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 to NULL , this function returns NULL .

Return data type

Date

Examples

Example formula Input Output
TODAY()
January 10, 2020 2020-1-10

Notes

TODAY is a synonym for CURRENT_DATE .

Design a Mobile Site
View Site in Mobile | Classic
Share by: