Legacy Qlik SAP Connector uses the format YYYY-MM-DD however, this has been changed on 6.1.2 of page 2 of the Release Notes (https://da3hntz84uekx.cloudfront.net/sap/6.1.2/1065/Qlik%20Connector%20for%20SAP%20Release%20Notes.pdf
) Due to this change, Qlik advise customers to start planning moving away from the NulldateLegacy but rather conform on the Numeric format stored in the QVD.
It is important to remember that Qlik recommends not to use the NulldateLegacy for new development moving forward (see the Qlik SAP Connector 6.3.2 Release Notes on page 2 for further information)
The two parameters Nulldate and NulldateLegacy
has to be changed to support legacy mode on the DATS date field to continue to store in YYYY-MM-DD format. Below must be changed in the SAP SQL Connector connection string: