>>>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")
And if lnSeconds >= 86400? < beg >
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
