microsoft sql server native client 10.0 sql server conversion failed when converting date and/or time from character string

[mbrady1973]

Good morning,

I am using Excel 2016 64 bit


I am trying to get a stored procedure with multivalue parameter to cooperate in Excel. In particular, I have identified a cell (B1) to get the "start date" and (B2) to get the "End Date".

Here is the call;

{call dbo.usp_rpt_prd_daily_production_reel(?,?,6)}

The two question marks are the dates.

When I refresh the data and use the above cell references, I get the following error.

microsoft sql server native client 10.0 sql server conversion failed when converting date and/or time from character string

Any ideas?

Also, it runs fine when I allow the start and end dates to prompt themselves.

Thanks