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.

Variables allow you to store and manipulate data and files in your workflows. They can be created by start events, forms, tasks, workflow actions, or automatically created when a workflow is run. For more information, see Variables.
Configure the Find interval between dates action
In the Designer page:
-
Click the Operations action group in the action toolbox.
or
Find actions by browsing action groups or by typing an action name or function in the Search field at the top of the action toolbox.
- Drag the Find interval between dates action to where in the workflow you want to determine the difference between two dates.
- Click the Find interval between dates action.
- Select the Start date.
- Select End date.
- Select a variable for Output to store the difference between the Start date and End date.
For more information on the fields, see Find interval between dates action fields.

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:
|
(n/a) |
Ouptut | The variable used to store the difference between the Start date and End date. | Decimal, Integer |