Calculate Date Difference
Verb: dateDifference
Calculates the time interval in days, hours, minutes, and seconds between two dates, returning the difference in a variable.
Syntax
dateDifference --subtractdate(DateTime) --fromdate(DateTime) (TimeSpan)=value
Inputs
| Script | Designer | Required | AcceptedTypes | Description |
|---|---|---|---|---|
| --subtractdate | Subtract | Required | Date Time, Date | "Date Time" variable to be subtracted from the value informed in the From parameter to calculate the difference. |
| --fromdate | From | Required | Date Time, Date | "Date Time" variable of which the value is subtracted. |
Outputs
| Script | Designer | AcceptedTypes | Description |
|---|---|---|---|
| value | Timespan | Time Span | Difference in days, hours, minutes and seconds between two dates.
1. The period (.) Separates the days from the hours; 2. The colon (:) separates hours from minutes and minutes from seconds. |
Example
Calculates the difference between two dates.
defVar --name subtractThisDate --type DateTime --value "2013-02-06 13:02:03"
defVar --name fromThisDate --type DateTime --value "2015-02-06 12:22:03"
defVar --name dateDifference --type TimeSpan
dateDifference --subtractdate ${subtractThisDate} --fromdate ${fromThisDate} dateDifference=value
logMessage --message "${dateDifference}" --type "Info"
// Calculates the difference between dates ("2013-02-06 13:02:03" "2015-02-06 12:22:03").
// Difference: (729.23:20:00).