>VFP documentation states that subtracting one time field from another gives the number of seconds between. I entered the following in the command window:
>
>firsttime = time()
>secondtime = time()
>btween = secondtime - firsttime
>
>?btween && should show the number of seconds elapsed between first 2 commands.
>
>this returns: 13:01:5813:01:55
>
>What's going on? How can I get the number of seconds betweeen two times?
I think you will be better to use DATETIME().