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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,218,690
Messages
6,143,940
Members
450,516
Latest member
shironokuro

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
Back
Top