Where is todays data?

[KB25]

My query will not return todays data! I am searching a date field in the table. (Short Date format) I've tried "Between [Start Date] And [End Date]" as well as ">=[Start Date] <=[End Date]" both of which will not return the current days records. If I enter the end date as tomorrow they will return todays data. If the "end date" equals a date other than today, the query will return all records entered on the "end date". Any ideas?
KB

 

[amym]

Try Between [StartDate] and Date()

Date() is the current date

 

[KB25]

Hi-
Thanks for the reply. Although I need the end date to be variable, I did try your suggestion and it did not work. I also tried just today's date in the criteria field and it returned zero records. (There are 3!)

 

[Taff]

Can you post a sample of your application.

Ant.

 

[KB25]

Hi All-
Found the problem! When I entered a record directly into the table the qry pulled it up. That pionted me to the form. The default value I use in the date field was "=Now()" instead of "=Date()"! I changed it to "=Date()" and it works fine.
Does anyone have any ideas as to why the Now() function was causing this?

Thanks to everyone for their help.
KB