Date query not working

[wolfm]

My date range criteria is not pulling records correctly.


My field is [First Move-in Date]
I want to return records with [First Move-in Date] as today and all dates up to seven days in the past.
I have tried the below criteria, and although they all work, none of them pull also todays date. They all pull from yesterday and 7 days prior.
Seems like these should work, but don't.

Between Date() And Date()-7
>=Date()-7 And <=Date()
Between Date()-7 And Date()

Thank you!!

[lfpm062010]

Simple answer is that you [First Move-in Date] have hours, minutes, and seconds data on it.

If you strip them out, the criteria that you have will work.

[wolfm]

Yes, the excel spreadsheet I import does contain times, also. I don't really need the times, so I can delete them.
When I tried that, it worked fine.

Thank you!

Simple answer is that you [First Move-in Date] have hours, minutes, and seconds data on it.

If you strip them out, the criteria that you have will work.