You are currently reviewing an older revision of this page.
When executing the intervalds() function and passing hours, minutes, and seconds that total greater than 591 hours, 31 minutes, and 23 seconds, the time interval returns as a negative number.
intervalds()
This issue has been reported to the Appian product team. The reference number for this issue is AN-78778.
quotient( ri!second + 60 * ri!minute + 3600 * ri!hour, 2147483) * intervalds( 0, 0, 2147483) + intervalds( 0, 0, mod( ri!second + 60 * ri!minute + 3600 * ri!hour, 2147483 ))
You can now use this expression rule in place of the original function.
Note: Similarly to the original intervalds() function, the value of each rule input must be non-null.
This article applies to all versions of Appian.
Last Reviewed: June 2017