Need to pass date parameters into query

Hello to all,

I'm trying to get the result of a query to an Access database into Excel and i'm facing problems while issuing the ADODB command, as follows:

Please Login or Register  to view this content.

In spite I have records that fill the criteria no records are returned. Can it be something related to syntax?
Many thanks in advance for any kind help.
OT

It's likely due to date formatting. Try changing date string format to something like 'yyyy-mm-dd'.

Many thanks for answering, CK76
Do you mean something like:

Please Login or Register  to view this content.

That gives me error: "Application uses a value of the wrong type for the current operation"
Thank you
OT

I believe Access by default uses 'yyyy-mm-dd' format.
Try using that format, if that doesn't work... may be use CDate(string) or DateValue(string)