3293195 - Supported Data Formats for Local Tables Created from CSV/JSON File Import

While creating a local table by importing a CSV/JSON file, the following error is triggered:

• An error occurred during the upload. Data couldn't be inserted. Value "<Date Value>" in the line of data
  <Table Details>
   is not supported for Date column format. The supported formats are "YYYY-MM-DD", "YYYY/MM/DD", "YYYY/MM-DD", "YYYY-MM/DD", "YYYYMMDD". 
  
  

• SAP Datasphere

Upload the CSV/JSON date records into the SAP Datasphere local table.

The provided date format is not supported by SAP Datasphere.

Adapt the date values in the CSV/JSON file to match the following supported formats:

• YYYY-MM-DD
• YYYY/MM/DD
• YYYY/MM-DD
• YYYY-MM/DD
• YYYYMMDD

• SAP Help - Creating a Local Table from a CSV File
• SAP Help - Load or Delete Local Table Data

  • This data upload does not support the data transformations available when creating a table from a CSV file (see Creating a Local Table from a CSV File).

    The data in your CSV file must match the table structure, including respecting all data types and structures.

    Date and time format support in this data upload is restricted as follows:
    Date columns: YYYY-MM-DD, YYYY/MM/DD, YYYY/MM-DD, YYYY-MM/DD, or YYYYMMDD
    Time columns: HH:MI:SS or HH24:MI[:SS]
    Date time columns: YYYY-MM-DD HH:MI:SS

DS, Upload, Local, Table,  Data, Date, Format, insert, column , KBA , DS-MD , Modeling (Data Builder) , Problem