Skip to main content
The Date Difference tool is relatively simple in its use but can fuel a lot of use cases. It’s used to find the difference in number of seconds, minutes, hours, days, months or years between two dates.
Note that our Syntax also supports date difference calculations. See more in the Syntax section.

​
Configuration

The Date Difference tool has three required input.
1

Latest date

Select the column containing the latest/most recent date
You can use our Current Datetime (UTC) helper if you want the latest date to be dynamic to the current date.
2

Earliest date

Select the column with the date you want to compare with. Typically this is an earlier date.
You can use our Current Datetime (UTC) helper if you want this date to be dynamic to the current date.
3

Select Unit

Select the unit you want to measure the difference in. You can select one of the following:
  • Seconds
  • Minutes
  • Hours
  • Days
  • Weekdays
  • Weeks
  • Months
  • Years