Problems with Date Range Parameters in query

[ethornto2346]

So I've created a query that prompts the user to enter a start date and an end date before they query is ran. I've noticed that the query will not pull any data that has the end date as the date entered. I've tried a few different expressions:

Between [Start Date] And [End Date]


>=[Start Date] and <=[End Date]

I've never had this issue before and not sure why now.

Is there something that I'm missing or a better formula/expression to use?

[pbaldy]

Likely your date field includes a time component. You can add 1 to the end date or use DateValue() on the field with the criteria.

[ethornto2346]

Ha yeah that did the trick. It was a time component that was being pulled from the table.

Appreciate it.

[pbaldy]

Happy to help, and welcome to the site by the way!