Extract date elements

This processor takes a column containing a date in standard ISO8601 format (ie, detected with meaning ‘Date’) and extracts various elements from this date to other columns

Each output column is optional. If you leave them empty, the corresponding information will not be extracted.

For more information about dates management, please see Managing dates.

Timezones handling

This processor provides timezone change features.

Output values

  • Month: 1-12

  • Day: 1-31

  • Day of week: 1-7 (1= Monday, 7 = Sunday); a Formula with the expression x % 7 + 1 would encode Sunday as 1.

  • Week of year: 1-53

  • Timestamp: UNIX timestamp of the date (in seconds since Epoch)