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 IconTransform Description
Task Factory Timezone Conversion Transform IconThe 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

OptionDescription
SourceSelect where the original Timezone data is found. This can be one of three types :

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

 Source and Output

OptionDescription
Data Source ColumnThe column where the original date is retrieved.

Note:  This column must be a date, DBTimeStamp, or DBTimeStamp2 data type.
Output ActionWhere 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.