SAP Knowledge Base Article - Public

2852920 - When Uploading Correct Date Format to Data Workbench, It Is Showing As '9999-Dec-31'

Symptom

You are uploading a xlsx file to Data Workbench with the correct date format of yyyy-mm-dd (9999-12-31), however the tool is showing the dates as 9999-Dec-31 and you are facing below error in validation step:

Valid date format is "yyyy-MM-dd" in Data Workbench

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to Data Workbench work center.
  2. Open Import view.
  3. Choose Complete Business Object.
  4. Select the object and download the xlsx template.
  5. Fill the template with the information and ensure to enter date format as yyyy-mm-dd (9999-12-31).
  6. Upload the file.
  7. See that Data Workbench tool is showing the dates as 9999-Dec-31.
  8. Go to validation step.
  9. The mentioned error appears.

Cause

This is happening because the format in Excel for the cell format was changed to Date. This could happen in case the date was copied and pasted from somewhere else, or if the cell format in Excel was changed manually.

Resolution

The cell format should always be Text.

 You can avoid the change to cell format by entering the value directly in cell. If you copy it from somewhere else, paste only the value and this will not change the cell format.

Keywords

data workbench; date format; yyyy-mm-dd; xlsx; , KBA , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP Cloud for Customer add-ins all versions