Calculate time difference between dates
Calculates the time difference between two dates. The time difference can be measured in years, months, days, etc.
Common use cases
- Data manipulation Wrkflows
- Time management
Category
| NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
|---|
| Start date | In the YYYY-MM-DD HH:MM AM/PM format, provide the start date. | Date | Yes | 2022-01-25 2:30 PM |
| End date | In the YYYY-MM-DD HH:MM AM/PM, provide the end date. End date should always come after start date | Date | No | 2022-12-03 4:00 PM |
Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data library section. These variables in the Data library section are the outputs of previous Wrk Actions in the Wrkflow.
Outputs (what you get)
| NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
|---|
| Difference in minutes | Difference in minutes between start date and end date | Number | Yes | 449370 |
| Difference in hours | Difference in hours between start date and end date | Number | Yes | 7489.5 |
| Difference in days | Difference in days between start date and end date | Number | Yes | 312.1 |
| Difference in months | Difference in months between start date and end date | Number | Yes | 10.3 |
| Difference in years | Difference in years between start date and end date | Number | Yes | 0.86 |
Statuses
| NAME | DESCRIPTION |
|---|
| Success | This status is selected when the difference between two dates was successfully calculated. |
| Unsuccessful | This status is selected in the event of the following scenarios:- The start and/or end dates are not provided |
Requirements