ConvertTimezone
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.