>I am calculation the difference between those datetime values. I would like to obtain a result such as 03:34:33. I already have the integer fields that contains the number of seconds. How can I convert that to HH:MM:SS?
Michel,
One possiblility is (if # seconds < 86400)
? ttoc( { 00:00:00 } + abs(DateTimeValue1 - DateTimeValue2), 2)
another is (# seconds > 86400)
local s
s = abs(DateTimeValue1 - DateTimeValue2)
?transform( int(s/3600)*10000 + mod(int(s/60),60)*100 + mod(s,60), '99999:99:99')
Gregory