How about this?
ltNow = DATETIME() && or whatever
? STRTRAN(TRANSFORM(ltNow),TRANSFORM(ttod(ltNow)))
>I read extract as substract... I guess, others gave you result you were looking for :)
>
>>>>I'm surprised not to find a function to extract time from datetime field. Is there one?
>>>>
>>>>Alex
>>>
>>>??datetime() - dtot(date())
>>
>>Interesting. That gives seconds since midnight.
>>
>>Alex
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell