>>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 Moore
Clientelligence