ODBC Connection with S4HANA database :When We Read Data from table date format is not in date format

[chandrajakkula]

Dear All,

We are created ODBC connection with S4Hana and extracting data from tables

But we are facing an issue of Date datatype its not detecting when we are changing to Date(FieldName,'DD-MM-YYYY') format.

its giving Year wrong.

may be the data read automatically changing default datatypes so how to set parameter in connection to read data in SAP data types 

please help us to pass the parameter / attribute to keep default datatype format while reading data in below connection string.

ODBC CONNECT TO [DSN=S4Hana_Dev;] (XUserId is fMTITIRJJaSGVCZJTKReM, XPassword is FSYVQIRNJbaGXSZNTLZCDZMGURKB);

[StarinieriG]

Hi

probably you could solve setting DateFormat on the first line of your script

SET DateFormat='format that is used in the table'; 

[Brett_Bleess]

Check the following post, might have what you need:

https://community.qlik.com/t5/QlikView-App-Development/Stored-procedure-error-while-passing-date-par...

Regards,
Brett