Fix Microsoft Access Date Criteria Returning Out-of-Range Records
Question details
The user needs a Microsoft Access parameter query to return records within a requested date range.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A query prompts for start and end dates to filter the Recruiter Interview Date field.
- Observed behavior
- The query returns records outside the requested range, even after date-range criteria were tried.
Open the query in Design View and locate the Recruiter Interview Date field and its Criteria row. Check whether the field contains time values as well as dates.
Correct the date boundaries and parameter types
Use this method to check the query criteria and ensure Access treats both prompts as dates.
In the query's Design View, enter >= [Enter the start date] And <= [Enter the end date] in the Criteria row under Recruiter Interview Date. Alternatively, enter Between [Enter the start date] And [Enter the end date].
On the Query Design tab, select Parameters. Enter [Enter the start date] and [Enter the end date] exactly as they appear in the criteria, and set each data type to Date/Time.
Inspect the Criteria and Or rows in Design View. Criteria on separate rows are joined with OR and can allow records that do not meet the date range; adjust the rows to match the intended logic.
Select Run and enter a start date and an end date. Compare the returned interview dates with both boundaries.

Check the interview date field's data type
Use this check if correct criteria still return unexpected records, especially when dates were imported as text.
Review Exported Access Data in WPS Spreadsheets
WPS Office is a free, lightweight alternative for everyday office work, with a familiar interface and Microsoft Office format compatibility. Export Access results to an Excel workbook to review them in WPS Spreadsheets; WPS does not repair Access queries.

Frequently Asked Questions
Does Between include the start and end dates in Access?
Yes. Between includes both boundary values. However, if the end date is entered at midnight, records with a later time on that date are not included.
Why do I still see dates outside the range after correcting the criteria?
In Query Design View, check for conditions on an Or row, which can admit additional records. Also check that the source field and both query parameters use the Date/Time data type.
How can I include every time on the end date?
For date-only prompts, use >= [Enter the start date] And < DateAdd("d", 1, [Enter the end date]) in the date field's Criteria row.
Where do I set the query prompt data types?
Open the query in Design View, select Parameters on the Query Design tab, and add each prompt with the Date/Time data type. The names must match the prompts in the criteria.




