You are here:
Date Difference
Calculate the duration between two selected date columns as days, months, or years.
- In a Transform node, select one date column in the Preview tab.
- Select the Formula button (
) in the Transform toolbar. - Select Date Difference.
- Configure the transformation.
- The start date is automatically filled with the date column you previously chose. To choose a different start date, cancel and restart.
- The end date is the value used to calculate the duration from the start date. Choose a date column from your data or the Now option to use the current date and time.
- Select whether to return duration as days, months, or years. Days are rounded up to the nearest value, while months and years include the selected number of decimal places.
- Optionally, change the label of the column that stores the result in the Column Label field.
- To add the transformation to the Transform node, click Apply.
The Preview tab shows the new Now column.
- To view the canvas area, click the Collapse button
.
After you run the batch data transform, you can view the calculated duration. The Now option uses the date and time when the batch data transform last ran, based on the UTC timezone.
Did this article solve your issue?
Let us know so we can improve!
