SAP Knowledge Base Article - Preview

3630588 - CSV imported as table with incorrect date format in sap datasphere

Symptom

The date is handled incorrectly when a csv file is imported through import button on local table editor. 

When date is xx01xxxx to xx12xxxx it imports as DDMMYYY from xx13xxxx to xx99xxxx it imports as YYYYMMDD producing incorrect results.


Read more...

Environment

SAP Datasphere

Keywords

csv import, incorrect format, date columns, sap datasphere, supported formats, YYYY-MM-DD, YYYY/MM/DD, YYYY/MM-DD, YYYY-MM/DD, YYYYMMDD, data import, table deployment , KBA , DS-DI-TAB , Table Persistency , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.