Query for a specific Date only

  • Thread starter Thread starter Fester
  • Start date Start date
F

Fester

I want to run a query only for the current date. I've tried =now()
under criteria, but it shows all dates. I know this is a newb
question, but I don't know how to ask it in the search
 
I tried that, and nothing populates at all. What am I missing?
Click to expand...

What's in the table field you're searching - a pure date, or a date/time
value? The Now() criterion should return nothing at all unless there happens
to be a record in the table with the current date and time to the microsecond
or so; a criterion of Date() will return a record only if the table contains a
date/time value with midnight last night.

If your table contains dates with times, and you want to get any record with
any time today, use a criterion
 
Back
Top