Procedure or function expects parameter which was not supplied

I am attempting to revise a chunk of code that was used to pull reporting from a database and point it to a new report with a different parameter. The code below is very close to accomplishing this. However, there seems to be an issue with either my variable "nEndDate" or the ADODB command. When I run the code I get an error stating that the procedure was not supplied with the expected parameter. The parameter required by the database must be 'datetime' format.

Any suggestions out there?

Please Login or Register  to view this content.

Good call JP. Your suggestion worked and led me to my next issue:

This line

Please Login or Register  to view this content.

had the variable 'nEndDate' in the wrong place. It should have been one more place to the right in the value spot.

Please Login or Register  to view this content.

The workbook is up and running now. Thanks for your help!