Using Date Parameters with a SQL Stored Procedure in Excel
Hi all,
I have connection in Excel that uses a SQL Server stored procedures with two date parameters. In the connection properties I can successfully run the query with the following command in the command text:
I get the following error:
Error converting data type varchar to date
The actual value in theses cells is shown as 01/09/2018 although it is formatted as 2018-09-01 and I presumed that using Range("I1").text instead of Range("I1").value would have worked??