Excel/SQL Hybrid - Run-time Error: Data type mismatch in criteria expression

Hello!

I am working on a database for entering and pulling old invoices. I am essentially using the excel document as a sql database and limiting user imput on the cells themself to avoid error as many of the people that will use it like to delete things.

How the document works:
The users can select fields from the Combo Boxes that will help them limit their searches. One of these limiting factors is a date range from range 1 to range 2. This is the only thing that I seem to have issues with:

Please Login or Register  to view this content.

To my understanding it is having trouble taking the dates entered in the cells and using it in SQL. It works just fine if you leave the date range blank, it is just when you use it as a search criteria.

The range however is extremely important so I cannot do without.

Let me know if you have any questions and I will do my best to answer them!