MS Access- How can I set a query that will pull by the current date?

Question

I set up a contact management database that will show by appointments on a daily basis. What formula would I use in the date column to spefiy to only pull the current days information?
I tried using the "NOW()" formula, but it wouldn't show todays information.

I appreciate your help!

Answer 1

select things
from data_table
where date_column=Date()

Answer 2

As previous people have pointed out put the Date() function into the query grid to pull today's records. If you really want to use the Now() function - which by design includes the time as well, you'll have to limit it to only the date. As such:

Format(Now(),"Short Date")

This will accomplish the same thing as the Date() function.

Good luck!

Answer 3

NOW() gives you the current date AND time so you only get records for the moment you ran the query.

DATE() will give you all the records on todays date.

You might also check out the TODAY() function, but I think DATE() is what you want

hope that helps

Answer 4

try this ex: SELECT * FROM table_name WHERE (Date = GETDATE())