Welcome to WebmasterWorld Guest from 18.104.22.168 , register , free tools , login , search , pro membership , help , library , announcements , recent posts , open posts Become a Pro Member
DateDiff function jefferson msg:1579814 8:18 pm on Oct 13, 2005 (gmt 0) i am trying to subtract two dates in the format 1/1/2005 13:45. I am trying to pull all records between two dates that the difference between the TimeIn(1/1/2005 15:00) and the TimeOut(1/2/2005 20:00) fields are > 3 hrs. i am using Access.
SuzyUK msg:1579815 8:47 pm on Oct 13, 2005 (gmt 0)
Hi, don't know if this is any help, but I tried a DateDiff query on a table I have ..
SELECT *, TimeIn, TimeOut FROM YourTable WHERE ((DateDiff("h",[TimeIn],[TimeOut])>3));
the asterisk, would be replaced with the other fields you actually want if the asterisk is too much.. but I think you have to name your time in/out fields specifically.
jefferson msg:1579816 9:36 pm on Oct 13, 2005 (gmt 0)
Thanks suzy, that code worked perfectly