Find interval between dates

Use the Find interval between dates action A tool for building the processes, logic, and direction within workflows. to calculate the amount of time difference between two DateTime values.

For example, users enter DateTime values into two Nintex form fields: Start date, and End date. You want to calculate the difference between the two dates in days for billing purposes.

You configure the Find interval between dates action to calculate the difference in days, and store the difference as a Decimal variable which you use in later in the workflow. The action calculates the difference between a DateTime value of December 17, 2018 and a DateTime value of December 21, 2018 is a Decimal value of 4.0.

Configure the Find interval between dates action

  1. Add the action to the workflow and open the action configuration panel. For more information, see Add, rename, and copy actions.

  2. Click the Find interval between dates action.
  3. Select the Start date.
  4. Select End date.
  5. Select a variable for Output to store the difference between the Start date and End date.

Find interval between dates action fields and settings

Field

Description

Variable

Start date

The first DateTime value used in the difference calculation.

DateTime

End date

The second DateTime value used in the difference calculation.

DateTime

Unit

The type of time unit for the interval between the Start date and End date. Select:

  • Days
  • Hours
  • Minutes
(n/a)
Ouptut The variable used to store the difference between the Start date and End date. Decimal, Integer