Shift Time Zone

Description

Converts a date from given timezone to destination time zone. A new column is created for the results.

Use

  • Argument:
    • Select an argument. (Date) 
  • Source time zone:
    • Enter source time zone.
      • Example: Europe/Berlin
  • Destination time zone:
    • Enter destination time zone.
      • Example: America/Los Angeles
  • Output field name:
    • Enter an output field name.

Example

Date valueSource time zoneDestination time zoneShiftTimeZone() returns
2022-02-17 05:30:00.000Europe/BerlinAmerican/Los Angeles2022-02-17 14:30:00.000
2022-02-17 14:30:00.000America/Los AngelesEurope/Berlin2022-02-17 05:30:00.000

Hero Platform_ Example

An example of this function can be found in Hero Platform_'s library of examples.

Download the example titled "function_Shift_Time_Zone" to see an example of this function. 

Type

Formulas