Microsoft Access 2016 query date/time extended

[wendell42]

I am trying to update some older queries that search for a date range (short date format in the table) ("Between [Enter Start Date (yyyy-mm-dd)] And [Enter End Date (yyyy-mm-dd)]" but after an upgrade, the dates in the table are now in the date/time extended format. When I run the query with the between statement it fails, giving me an error "Data type mismatch in criteria expression"

I want the user to be able to be prompted to enter the date range they need the query to pull from. How can I put the expression in the query to prompt them using the date/time extended format of the field in the table? I haven't been able to find anything online to help me out.

Any assistance is greatly appreciated.

 

[jackd]

See this from Microsoft.

I would try to reset the fields to Date/Time. I suggest you experiment on a copy of the database or table involved.