Date

This transformation copies and transforms dates from one field to another. Reads a date/time from the Source Field (parsed using Date Format), and writes it to the Destination Data Field using a second Date Format.

Settings:

Setting	Description
Source Field	Field Name or JSON dot-notation to the source field
Date format	Date/Time format of the Source Field
Destination Data Field	Field Name or JSON dot-notation to the target field
Date format	Date/Time format of the Destination Field.

Behavior:

If the Source Field's format is Unix, the source is interpreted as a Unix epoch string. If the Destination Date Format is Unix, the date is converted to seconds since epoch. Otherwise, we use standard RFC time formats e.g. RFC1123z ("Mon, Jan 02 2006 15:04:05 MST").