Date & time

Shifts or reformats a date field.

Add or subtract time, or cut a date-time down to its date or its time. Rows whose value is missing or unreadable pass through untouched.

Properties

• Field: the date field. Required.
• Operation: add, subtract, to-date, or to-time. Required.
• Amount: how much, for add and subtract.
• Unit: what the amount counts: minutes, hours, or days.
• Into: where the answer lands. Defaults to the field itself.