Compute difference between dates
Compute the difference between an ISO-8601 formatted date column (
yyyy-MM-ddTHH:mm:ss.SSSZ
) and another time reference: the current time, a fixed date, or another column.
Options
Time since column
Column containing data in ISO-8601 format. Use a Prepare step to parse your data into this format if it isn’t already.
Until
Choose the second time reference to compute the difference — now, another date column, or a fixed date.
Output time unit
Determine the unit of time in which to express the datetime difference — year, month, week, day, hour, minute or second.
Output column
Column into which the datetime difference will be written.
Reverse output
Multiply the computed difference by -1, reversing it:
3
days
→
-3
days
.