The ConvertTimezone function converts date and time values to the specified time zone.

For more information (included use case exercises) about date functions, see the Common Date Functions and Use Cases QuickStart.

Syntax

ConvertTimezone(date, timezone)

The function has these arguments:

date
Required
The column of date and time values
timezone
Required
The IANA time zone of the desired output

Examples

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

Converts values in the Date column to the corresponding values for the America/Los_LosAngeles (Pacific time zone) date and time.

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

When the account time zone is America/Los_Angeles (Pacific time zone), the function generates 2014-07-18 13:58:00 as the equivalent America/New_York (Eastern time zone) date and time.

Related functions


Was this page helpful?
Yes No