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
Date & Time
Inputs (what you have)
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
N/A