General Date Criteria 1

[smoker1]

In my linked table, there is a general date field (7/23/01 10:59 AM). I am writing a query for a real-time report & therefore, need to query the fields whose date criteria equals the current date. I originally tried =Now() which didn't work. Entering #7/23/01# works, but it doesn't serve us purpose when the report is run tomorrow needing tomorrow's date.

Is there anyway to avoid changing the date every day?

Thank you for your information!

Angela

 

[gwinn7]

The Now() function didn't work because it also returns the time which will probably not match anything in your table.

Here is a sample WHERE clause that does the principle of what you are asking...

WHERE (((Format([BookDate],"mm/dd/yyyy&quot)=Format(Now(),"mm/dd/yyyy&quot));

I think there is probably even a faster way, but I can't think of it right now.

Gary
gwinn7