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

SAP Knowledge Base Article - Public

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

Symptom

Using Data Workbench, you require to Update the Contacts Status from Active to Obsolete. Therefore, you Export the Contacts from the Export view and make the Status modifications to the same file. On uploading the file in the Update view, system throws the error:

Cannot update the data file. Please correct the following errors: 2

CSVHeader :EndDate

Error Information :Invalid date format entered

Solution :Valid date format is "yyyy-MM-dd"

CSVHeader :CreationDateTime

Error Information :Invalid date format entered

Solution :Valid date format is "yyyy-MM-dd" or "yyyy-MM-dd'T'HH:mm:ss'Z'"

Environment

SAP Hybris Cloud for Customer

Reproducing the Issue

To Export the Contacts:

  1. Login to the HTML5 client
  2. Go to Data Workbench workcenter
  3. Go to Export tab
  4. In the search field, select the object Contact
  5. Radio button Select Data
  6. Select field Contact ID Equals To XXXXX (where XXXXX represents the Contact)
  7. Select Next
  8. Export Data
  9. Go to the Monitor tab and Download the exported file
  10. Able to see different date formats for the below fields
  11. Start Date: YYYY-MM-DD
  12. End date: MM/DD/YYYY
  13. Creation Date Time: MM/DD/YYYY
  14. Make the required changes to the field as below:
  15. Status: 4
  16. Status Text: Obsolete
  17. Save

 

To Upload the file with Contact Status:

  1. Login to the HTML5 client
  2. Go to Data Workbench workcenter
  3. Go to the Import tab
  4. Select the radio button Individual Objects
  5. Go to Update tab
  6. Select the object Contact
  7. Select Next and Browse for the file
  8. Select Upload
  9. Choose Next
  10. System throws errors on Date format

Cause

Data Workbench accepts date format YYYY-MM-DD

Resolution

Once you export the CSV file, open the same file with Notepad++

You will be able to see that the Date format is YYYY-MM-DD

Edit the Contact Status and follow the below steps:

  1. Go to Menu and select the option Encoding
  2. Select the option Convert to UTF-8
  3. Save the file on Menu->File->Save as
  4. Name the file and add the extension .CSV , Example: filename.csv
  5. Upload this file in Data Workbench 

Note: You may use software which is approved by your organization/IT.

Keywords

Date format in Data Workbench, Invalid date format entered, Valid date format , KBA , valid date format is "yyyy-mm-dd" , invalid date format entered , yyyy-mm-dd't'hh:mm:ss'z' , yyyy-mm-dd , LOD-CRM-INT-DWB , Data Workbench , How To

Product

SAP Hybris Cloud for Customer all versions