Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Jagveer
New Contributor III

Stored procedure error while passing date parameter

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.

1 Solution

Accepted Solutions
Highlighted
Jagveer
New Contributor III

Re: Stored procedure error while passing date parameter

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

Cheers!!

View solution in original post

3 Replies
Highlighted
Luminary
Luminary

Re: Stored procedure error while passing date parameter

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');
Blog: WhereClause   Twitter: @treysmithdev
Highlighted
Digital Support
Digital Support

Re: Stored procedure error while passing date parameter

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Highlighted
Jagveer
New Contributor III

Re: Stored procedure error while passing date parameter

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

Cheers!!

View solution in original post