>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')