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
Highlighted
chandrajakkula
New Contributor II

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

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);

2 Replies
Partner
Partner

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

Hi

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

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

Highlighted
Digital Support
Digital Support

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

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

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.