Get Time Between Date/Times
Overview
This action calculates the following times between two Date/Time values: milliseconds, seconds, minutes, hours, days, years.
Inputs
First Date/Time
The first Date/Time value used to calculate the time between two Date/Times.
| Type |
|---|
| Date/Time |
Second Date/Time
The second Date/Time value used to calculate the time between two Date/Times.
| Type |
|---|
| Date/Time |
Absolute Value Output
If set to true, the output values are always a positive number.
| Type | Default |
|---|---|
| Boolean | false |
Rounding Mode
The rounding mode used when calculating the time. The value must be a valid Rounding Mode value.
| Type | Default |
|---|---|
| Text | HALF_EVEN |
Decimal Scale
How many decimal points are used when calculating the time value between two Date/Time fields.
| Type |
|---|
| Number |
Outputs
Milliseconds
The number of milliseconds between the two Date/Time values.
| Type | Variable Name |
|---|---|
| Number | milliseconds |
Seconds
The number of seconds between the two Date/Time values.
| Type | Variable Name |
|---|---|
| Number | seconds |
Minutes
The number of minutes between the two Date/Time values.
| Type | Variable Name |
|---|---|
| Number | minutes |
Hours
The number of hours between the two Date/Time values.
| Type | Variable Name |
|---|---|
| Number | hours |
Days
The number of days between the two Date/Time values.
| Type | Variable Name |
|---|---|
| Number | days |
Years
The number of years between the two Date/Time values.
| Type | Variable Name |
|---|---|
| Number | years |