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
© 2020 Appian. All rights reserved.