ConvertTimezone

The ConvertTimezone function converts datetime values to the specified time zone.

Syntax

ConvertTimezone(date, timezone, [from_timezone])

Function arguments:


date	(required) The datetime value to convert.
timezone	(required) The TZ identifier of the IANA time zone to which the datetime value is converted. See List of TZ database time zones for reference.
from_timezone	(optional) The TZ identifier of the IANA time zone from which the datetime value is converted. Defaults to the organization account time zone when the argument is unspecified.

date

(required) The datetime value to convert.

timezone

(required) The TZ identifier of the IANA time zone to which the datetime value is converted. See List of TZ database time zones for reference.

from_timezone

(optional) The TZ identifier of the IANA time zone from which the datetime value is converted.

Defaults to the organization account time zone when the argument is unspecified.

Notes

The timezone and from_timezone arguments support a column of IANA time zones as text to perform dynamic time zone conversion.

Examples

ConvertTimezone([Date], "America/Los_Angeles")

Interprets values in the Date column as datetime values in the organization account time zone, then converts them to the equivalent datetime values in America/Los_Angeles (Pacific) time.

ConvertTimezone(Date("2014-07-18 10:58:00"), "America/Los_Angeles", "America/New_York")

Interprets 2014-07-18 10:58:00 in America/New_York (Eastern) time and converts it to 2014-07-18 07:58:00 in America/Los_Angeles (Pacific) time.

ConvertTimezone(Date([Date]), [Time zone], [From time zone])

Converts the text "2025-01-01 00:00:00" in the [Date] column to a date, then converts it from the time zone specified in [From time zone] to the time zone specified in [Time zone].