G Guest Jun 26, 2005 #1 How do i make query to ignore a date in the Date/Time field in Access 2003? Thank you TT
G Guest Jun 26, 2005 #2 If you want to return only the time from the field then use ' Not to include seconds format(DateField,"hh:mm") or format(DateField,"short time") ' To include seconds format(DateField,"hh:mm:ss") or format(DateField,"Long time")
If you want to return only the time from the field then use ' Not to include seconds format(DateField,"hh:mm") or format(DateField,"short time") ' To include seconds format(DateField,"hh:mm:ss") or format(DateField,"Long time")
J John Vinson Jun 26, 2005 #3 How do i make query to ignore a date in the Date/Time field in Access 2003? Thank you TT Click to expand... Tim, you've had this question answered five times in three newsgroups. Please have a LITTLE bit of patience, and read the answers. The TimeValue() function will return a Date/Time value on December 30, 1899 which will match a pure time criterion. John W. Vinson[MVP]
How do i make query to ignore a date in the Date/Time field in Access 2003? Thank you TT Click to expand... Tim, you've had this question answered five times in three newsgroups. Please have a LITTLE bit of patience, and read the answers. The TimeValue() function will return a Date/Time value on December 30, 1899 which will match a pure time criterion. John W. Vinson[MVP]
D Douglas J. Steele Jun 26, 2005 #4 John Vinson said: Tim, you've had this question answered five times in three newsgroups. Please have a LITTLE bit of patience, and read the answers. Click to expand... More than 3 newsgroups, John...
John Vinson said: Tim, you've had this question answered five times in three newsgroups. Please have a LITTLE bit of patience, and read the answers. Click to expand... More than 3 newsgroups, John...
