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

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'"

SAP Hybris Cloud for Customer

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

Data Workbench accepts date format YYYY-MM-DD

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.

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

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions