General information
Category:
Coding, syntax & commands
>>>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)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only