Skip to main content

Varicent ELT Help Center

Date diff

Abstract

Finds the difference between two dates.

Finds the difference between two dates. Adds a new column to your data. You can calculate the difference based on these values:

  • Current date

  • Column

  • Constant date

When to use this tool

Use this if you want to know how much time has passed between two dates.

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. In , add your data source.

  2. Click symon_add_icon.png + Tool.

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

    Tip

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

  4. Connect the tool to your data set.

  5. In the configuration pane, enter the following information:

    Table 39. Date diff tool configuration

    Field

    Description

    New column name

    Enter the name of your new column.

    Unit of time

    Select the time interval:

    • Year

    • Month

    • Day

    • Hour

    • Minute

    • Second

    Start date

    Select the starting time, such as Current time, Column or Constant time.

    End date

    Select the ending time, such as Current time, Column or Constant time.