>>>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.

Erik,

I am puzzled, why don't you just subtract the two datetime fields. I don't see the need for the function above.

dt1 is 1997/10/29 12:58:51 PM
dt2 is 1997/10/29 12:58:57 PM

dt2 - dt1 is 6 (seconds)