Convert To UTC

This task will convert date fields to the given format, with the given offset.


Configuration

To use this task go to the task tab in your job. Select the task from the drop down and click the plus circle to configure the task. Click done after making any changes to save.

Condition check

It will execute the task when the condition's result is 'true', 't', 'on', '1', or 'yes' (case-insensitive), or run on all conditions if left empty. This condition is evaluated for each document, determining whether the task should be executed based on the specified values.

Example: If I only want to run this task for PDF documents I would use the expression: equals('#{rd.mimetype}',"application/pdf")

Date Fields to Convert

A comma delimited list of repository fields or the output of calculated field.

  • If you do not supply field names, the task will attempt to process all the Job's Date/Time mappings. Note: only calculated field mappings are available to job processors.

Offset

Timezone offset. List of off set UTC Time Zones

Define Date Time Format Check box

Check to define an output format, uncheck to return default format (i.e. 2019-11-05T16:00:00Z)

Date Time Format

If you check the box to define the date and time you will enter the final format in this field.


Examples

In the following example 3Sixty will convert all the times during the integration to GMT - 05:00 and list the date/times as Year-Month-Date Hours:Minutes


API Keys

Processor: convertToUTCTask

Key

Display Name

Type

use_condition Check a condition before executing this task. Boolean

task_condition

Condition

String

task_stop_proc

Stop Processing

Boolean

utc_fields

Date Fields to Convert

String

tz_offset

TimeZone Offset Integer (ie -5 for GMT -05:00).

String

definedtf

Define Date Time Format

Boolean

date_time_format

Date Time Format

String