topic Re: Stored procedure error while passing date parameter in QlikView

Stored procedure error while passing date parameter

Jagveer — Thu, 05 Sep 2019 15:47:17 GMT

Hi,

I have a stored procedure in SAP HANA DB that i am trying to call in qlikview. i need to pass a date parameter to the procedure but can't seem to find the right syntax. the procedure ahas 3 different select statements

below is the syntax i am using

ODBC CONNECT TO [SAP HANA - PRD] (XUserId is NcbOPBdKVaUKEJNZ, XPassword is LRZVKNFLZbSKGEVGGSaMDGRMHLQeUQC);

SQL call Sales_QTR('05/09/2019');

this is the error i am getting

General error;303 invalid DATE, TIME or TIMESTAMP value: Error while parsing 05/09/2019 as DATE at function __typecast__() (at pos 24)

I have also tried using a date variable and then passing it as parameter, it doesn't allow using a variable for parameter call

Please help.

Re: Stored procedure error while passing date parameter

treysmithdev — Tue, 17 Sep 2019 14:55:54 GMT

SAP HANA's default date format is YYYY-MM-DD, I would try to pass the date as such.

SQL call Sales_QTR('2019-09-05');

Re: Stored procedure error while passing date parameter

Brett_Bleess — Thu, 19 Sep 2019 12:31:18 GMT

Jagveer, did Trey's suggestion work for you? If so, please be sure to give him credit by using the Accept as Solution button on his post to mark that as the solution, this will also let others know this worked. I would probably suggest checking out the SAP Community on this one as well given you may be more likely to get further answers there versus our forums. Just another idea in case you are still trying to get things to work.

Regards,
Brett

Re: Stored procedure error while passing date parameter

Jagveer — Thu, 19 Sep 2019 12:42:36 GMT

Thanks for the idea Trey. this format did not work but i passed the date format on SAP server 'yyyymmdd' which worked.

Cheers!!