Error converting data type varchar to datetime when using stored procedure

Wed, 08 Jun 2011 08:06:23 GMT

Hi all,

I use a specific stored procedure for 2 years now.

And without any update the last months I get the following error since last week...

"ERROR converting data type varchar to datetime"

I use the following code:

Qlikview parameters who gives me first day last year and one year in the future:

LET vStartDate = DATE(YEARSTART(NOW(),-1), 'YYYY-MM-DD');

LET vEndDate = DATE(MonthEng(Addmonths(NOW(),12)), 'YYYY-MM-DD');

LET paraA = 1

LET paraB = 1

Using in Qlikview

SQL EXEC "$(vDatabase)".dbo.[STOREDPROCEDURE] '$(paraA)', '$(vStartDate)', '$(vEndDate)', '$(paraB)';

So it works for 2 years but the last month not....

How can this happen? The error is about the two date I think...

Can somebody help me please?

Kind Regards,

Martijn

Re: Error converting data type varchar to datetime when using stored procedure

agomes1971 — Tue, 01 Jul 2014 09:44:22 GMT

Is this already solved? Or do you still have the same problem? In the Store Procedure you're invoking the dates with wich type?