Date diff
Use the Date diff tool to find the difference between two dates, such as how much time has passed between two dates. Adds a new column to your data. You can calculate the difference based on these values:
Current date
Column
Constant date
Important
The Date diff tool does not include the start date. If you are required to perform a date diff that consists of the start date, you must use the Formula tool to add 1 to the calculation.
For example, with the date range of 1/1/2025 to 1/3/2025, this would be treated as a two-day difference between the start and end dates using the Date diff tool. If the start date were included, it would be a three-day difference.
Input
The Date diff tool requires one data input.
Configuration
Use the following configuration options to help create your Date diff configuration.
Go to the Pipes module from the side navigation bar.
From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.
In Pipe builder, add your data source.
Click
+ Tool.
In the search bar, search for Date diff. Click + Add tool.
Tip
You can also find the Date diff tool in the Calculate section.
Connect the tool to your data set.
In the configuration pane, under New column name, enter the name of your new column.
Under Unit of time, select the time interval:
Year
Month
Day
Hour
Minute
Second
Under Start date, select the starting time, such as Current time, Column, or Constant time.
Under End date, select the ending time, such as Current time, Column or Constant time.