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.
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.
Kindly note that Appian Technical Support provides the above SAIL code as-is without any express guarantee of functionality. Readers will need to test and adjust the code as necessary.
This article applies to all versions of Appian.
Last Reviewed: June 2017
© 2022 Appian. All rights reserved.