These docs are for v1.0. Click to read the latest docs for v1.2.

ISODATE

Creates a date from an ISO8601-formatted string. See ISO8601 formatting for more details.

Syntax

=ISODATE(value)

Arguments

ArgumentTypeDescription
valueStringISO8601-formatted string

Examples

In the following examples, the current browser has a timezone offset of -7 hours. For more information about offsets see UTC Offset.

=ISODATE("2020-01-01T00:00:00+0000")Dec 31, 2019 5:00 PM

=ISODATE("2016-06-01T04:15:00+0000")→`May 31, 2016 10:15 PM

=ISODATE("2020-02-03")Feb 3, 2020 12:00 AM

=ISODATE("2020-01")Jan 1, 2020 12:00 AM

=ISODATE("2021-W01-1")Dec 30, 2019 12:00 AM