dates and times

[Guest]

Hi all
This is a little tricky:

I have two fields: F1 and F2 each are formated Date/Time "01/01/2001 4:30
PM" and "01/03/2001 4:35 PM" respectively. I want to know, can I get what the
time difference between the two fields? The answer would be 48 hrs and 5
minutes (48:05) is there a way I can do this? [F2]-[F1]??

Thanks

 

[Duane Hookom]

Do you understand the difference between "formated" which generally refers
to the display and the actual value which refers to the value that is saved
in the table? Can we assume F1 and F2 are both date/time fields? If so,
check Doug Steele's page at
http://members.rogers.com/douglas.j.steele/Diff2Dates.html.