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.