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.
This processor provides timezone change features.
- Month: 1-12
- Day: 1-31
- Day of week: 1-7 (1= Monday, 7 = Sunday); a Formula with the expression
x % 7 + 1would encode Sunday as 1.
- Week of year: 1-53
- Timestamp: UNIX timestamp of the date (in seconds since Epoch)