> ## Documentation Index
> Fetch the complete documentation index at: https://docs.less.tech/llms.txt
> Use this file to discover all available pages before exploring further.

# Date Difference

> Calculate the difference between date columns in seconds, days, months, etc.

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>
  Note that our Syntax also supports date difference calculations. See more in the [Syntax](/canvas/syntax) section.
</Note>

## Configuration

The Date Difference tool has three required input.

<Steps>
  <Step title="Latest date">
    Select the column containing the latest/most recent date

    <Tip>
      You can use our Current Datetime (UTC) helper if you want the latest date to be dynamic to the current date.
    </Tip>
  </Step>

  <Step title="Earliest date">
    Select the column with the date you want to compare with. Typically this is an earlier date.

    <Tip>
      You can use our Current Datetime (UTC) helper if you want this date to be dynamic to the current date.
    </Tip>
  </Step>

  <Step title="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
  </Step>
</Steps>