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

The most interesting thing here, that I really tried to test simple subtraction first, when I saw initial question, and it didn't work on my machine! When I saw Alex reply, I tried again and it worked::))