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

Evan- you are right... Alex Z. also pointed this out.
The reason I asked the question in the first place was that I had tried that before using time(). Well, time returns a string, so subtracting a string from a string doesn't exactly give the results I was looking for. For some reason I was thinking that subtracting datetime fields returned the same results. I am really kicking myself for not just trying it first. Still a pretty fancy (though now irrelevant) piece of code on Edward's part... :-)