• Account
• API
• Integrations
• Enterprise
• Resources
Calculate the difference between two dates
• 06 Jul 2022
• Dark
Light

# Calculate the difference between two dates

• Dark
Light

Finding the difference between two dates can be helpful for many workflows. Using the DATETIME_DIFF() function in the example below, we'll find the difference - in days - between two dates. Note that "Payment Received" and "Invoice Billed" are the exact names of our two columns below:

``````DATETIME_DIFF(
{Invoice Billed},
'days'
)
``````

Another common use of `DATETIME_DIFF()` is to find the difference between a record's date and today's date. You can use `DATETIME_DIFF()` in combination with the `NOW()` formula to dynamically find the difference from today's date.

``````DATETIME_DIFF(
NOW(),
{Invoice Billed},
'days'
)
``````

For another example, you can also use `DATETIME_DIFF` to find someone's age when given their birthday:

``````DATETIME_DIFF(
{Birth Date},
NOW(),
'years'
) * -1
``````

## Displaying in decimal format

In another example, if you need to measure the time an employee spent working each day, you could create two date field to track their clock in and clock out times. Using a DATETIME_DIFF() function like the following, you can display the total hours worked for the day.

``````DATETIME_DIFF({Clock Out},{Clock In},'minutes')  / 60
``````

## Displaying in duration format

If you need to display this difference in duration format instead, you can make a small adjustment to your formula, using `seconds` instead of `minutes`, and removing / `60` from the end of the formula.

``````DATETIME_DIFF({Clock Out},{Clock In},'seconds')
``````