>>>Is there a way to subtract one datetime field from another to find the amount of time between them? I asked this question a few weeks ago but my proble then was solvable using seconds(). This time it isn't.
>>
>>I guess you should use functions:
>>Procedure gettime
>>Parameters dt1,dt2
>>return 3600*24*(ttod(dt1)-ttod(dt2)+3600*(hour(dt1)-hour(dt2))+ ;
>>60*(minute(dt1)-minute(dt2))+sec(dt1)-sec(dt2)
>>You can also format returning value back to days:hours:min:sec
>
>Thanks Ed! This code worked almost as is (missing a paren) to return the number of seconds between the parameters. IF you rattled that off of the top of your head, I am truly impressed. Thanks again.
Yes, off the top:)
Edward Pikman
Independent Consultant