Task Factory Timezone Conversion Transform

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.

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