Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
tmumaw
Valued Contributor

SAP Connector - Dates are Numeric

Hi all,

I just updated to 12.10 SR6 along with upgrading my SAP Connector.  I have run into  major issues all the dates now in my QVD's I build from SAP have a format of YYYY-MM-DD.  How can I change how the connector stores the dates in my QVD's?  I need a format of MM/DD/YYYY and I don' t want to change all my extracts.  Must be a setting on the connect string but where?

Thanks

Tags (1)
5 Replies

Re: SAP Connector - Dates are Numeric

The SAP Connector comes in many versions, each with their own particularities.

From which version to which version did you mgrate?

tmumaw
Valued Contributor

Re: SAP Connector - Dates are Numeric

 

Old SAP connector: 5.7

 

New SAP connector: 6.4

 

Re: SAP Connector - Dates are Numeric

Inbetween we had SAP Connector v6.1 that introduced considerable data processing changes. Luckily, that release also introduced additional options to configure "legacy"-style data processing in the SAP Connector. Maybe those can solve your conversion problem.

Do a test with the extraction of a single SAP table with (multiple) date fields and configure legacy mode in the connection string. Then check the resulting QVD to see in what format they are stored.

Useful discussion about a similar issue: SAP Field interpretation as in Version 5.x

tmumaw
Valued Contributor

Re: SAP Connector - Dates are Numeric

Thanks Peter.  One of my co-workers found that same thread.  Sounds like what all of my issues are.  Testing it out right now.  

micheledenardi
Valued Contributor

Re: SAP Connector - Dates are Numeric

I don't think the legacy data processing can solve your problem.

Check this page for all connection parameters:

https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/6.4/QV-connection/SAP-...

In your case I think you must change your extractors by insert date(SAP_FIELD,'MM/DD/YYYY') as SAP_FIELD during the extraction.