Date/Time Criteria

[Guest]

I have a field in table with the data type date/time.
In a query, I want to get all the records that were done on say, 1/15/2006,
without regard to the time they were done.
How do I set the criteria? #1/15/2006# doesn't work because I'm not allowing
for the time component, I guess.
Thanks,

 

[Rick Brandt]

I have a field in table with the data type date/time.
In a query, I want to get all the records that were done on say, 1/15/2006,
without regard to the time they were done.
How do I set the criteria? #1/15/2006# doesn't work because I'm not allowing
for the time component, I guess.

SELECT *
FROM TableName
WHERE DateField >= #1/15/2006#
AND DateField < #1/16/2006#

 

[Guest]

Excellent!
Thanks very much.
--
Howard

SELECT *
FROM TableName
WHERE DateField >= #1/15/2006#
AND DateField < #1/16/2006#

 

[John Vinson]

I have a field in table with the data type date/time.
In a query, I want to get all the records that were done on say, 1/15/2006,
without regard to the time they were done.
How do I set the criteria? #1/15/2006# doesn't work because I'm not allowing
for the time component, I guess.
Thanks,

Try a criterion

= CDate([Enter search date:]) AND < DateAdd("d", 1, CDate([Enter search date:]))

John W. Vinson[MVP]