Criteria for Date/Time Field - Cumbersome

  • Thread starter Thread starter tbl
  • Start date Start date
T

tbl

When I want to quickly query for a certain date, on a field
that is a Date/Time datatype and contains both date *and*
time information, it sure seems a pain to have to use the
"between" statement. Is there a better way?
 
Sure -- use a query like this:

SELECT * FROM Tablename
WHERE DateValue([DateTimeFieldName]) = #06/29/2006#;
 
Back
Top