Documentation forTask Factory

Task Factory Timezone Conversion Transform

 Task Factory users running version 2020.1.4 or older (released prior to May 27, 2020): There's an important Task Factory update. Please visit here for more details.

Timezone Conversion Transform

Transform Icon Transform Description
Task Factory Timezone Conversion Transform Icon The Timezone Conversion Transform easily converts a date from one Timezone to another using the IANA TZ Database.

Note:  The Timezone Conversion Transform automatically accounts for daylight saving time (DST) adjustments.

Task Factory Timezone Conversion Transform

Original Timezone / Converted Timezone

Option Description
Source Select where the original Timezone data is found. This can be one of three types :

  • Static Value
  • Variable
  • Column
Enter Static Value / Variable, Input Column Depending on where the source is stored, you use this text box to point to the source.

 Source and Output

Option Description
Data Source Column The column where the original date is retrieved.

Note:  This column must be a date, DBTimeStamp, or DBTimeStamp2 data type.
Output Action Where the converted data is sent. There are two options.

  • Output To A New Column - In this mode, a new column name is given in the Output Column textbox, and then you select the output data type in the Column Type drop down.
  • Replace Source Column - In this mode, select a source data column to replace its value upon conversion.