>>You don't have to use constant at all.
? RIGHT(TTOC( DTOT(DATE()) + lnSeconds),8)
>
>That's another good way to achieve the same.
I realized that it would produced desired result only if SET HOURS set to 24. Here's the code that will return correct result regardless of any date/time settings.
? TRANSFORM(RIGHT(TTOC( DTOT(DATE()) + lnSeconds,1),6), "@R 99:99:99")
--sb--