=Date() Problem

  • Thread starter Thread starter Justin
  • Start date Start date
J

Justin

I have a query and want to return records only with today's date. However,
when i use =Date() in the criteria field i only get one result (i have three
with the same date right now and one with different date) any suggestions?
 
I have a query and want to return records only with today's date. However,
when i use =Date() in the criteria field i only get one result (i have three
with the same date right now and one with different date) any suggestions?
Click to expand...

Correct the error in your query, or in your data.

Since we can't see either, you'll need to post some more information!

At a GUESS, your table's date field contains both a date and time component,
and you'll need a query such as
= Date() AND < Date() + 1
Click to expand...

to get all records from #2/3/2010 00:00:00# through #2/3/2010 23:59:59#.
 
You probably have time with those dates so they would look like this --
40212.6328703704 and =Date() will be 40212.0
So you can use =Date()+.999999
Or remove the time from your field -- Int([MyDate])
 
Back
Top