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

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

chandrajakkula — Tue, 17 Sep 2019 13:56:26 GMT

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 — Tue, 17 Sep 2019 13:59:54 GMT

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

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

Brett_Bleess — Thu, 26 Sep 2019 21:36:46 GMT

Check the following post, might have what you need:

Regards,
Brett