Skip to main content

Varicent ELT Assistant

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.

Configuring the Date diff tool

  1. Go to the Pipes module from the side navigation bar.

  2. 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.

  3. In Pipe builder, add your data source.

  4. Click symon_add_icon.png + Tool.

  5. In the search bar, search for Date diff. Click + Add tool.

    Tip

    You can also find the Date diff tool in the Calculate section.

  6. Connect the tool to your data set.

  7. In the configuration pane, under New column name, enter the name of your new column.

  8. Under Unit of time, select the time interval:

    • Year

    • Month

    • Day

    • Hour

    • Minute

    • Second

  9. Under Start date, select the starting time, such as Current time, Column, or Constant time.

  10. Under End date, select the ending time, such as Current time, Column or Constant time.