Find interval between dates
Use the Find interval between dates action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. 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
-
Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.
- 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.
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:
|
(n/a) |
Ouptut | The variable used to store the difference between the Start date and End date. | Decimal, Integer |