Microsoft Access 2016 query date/time extended

wendell42

Board Regular
Joined
Feb 10, 2005
Messages
137
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.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,176,138
Messages
5,901,574
Members
434,906
Latest member
Prabhu_Churi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top