>>>>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:)
Ed,


Nice code, but dt2-dt1 returns the number of seconds.