date problem

[Brad Onuch]

hello,
i have the following in a date field "3/20/2004 9:55:36 AM" from a log
file

i cannot seem to query different dates (without the time stamps) with
the following?

SELECT tblWhseBinUpdLog.*, tblWhseBinUpdLog.DateTime
FROM tblWhseBinUpdLog
WHERE (((tblWhseBinUpdLog.DateTime)=Date()));

what am i doing wrong? i don't need the time i just want to qry by date.

thanking all in advance whom reply

brad.

 

[Douglas J. Steele]

WHERE (((DateValue(tblWhseBinUpdLog.DateTime))=Date()));

 

[Duane Hookom]

Try:
WHERE DateValue(tblWhseBinUpdLog.DateTime)=Date();