Discussion Board for collaboration related to QlikView App Development.
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);
probably you could solve setting DateFormat on the first line of your script
SET DateFormat='format that is used in the table';
Check the following post, might have what you need: