3399428 - Error “Invalid Date Value” When Importing Data

You have imported some data via Data Import tool, and you received one of the errors below:

• {Entity Name}: Invalid date value in field {field name} in row {X}, externalId {Y}. The expected date format is YYYY-MM-DD.
• {Entity Name}: Invalid date value in field {field name} in row {X}. The expected date format is YYYY-MM-DD'T'HH:mm:ss'Z'.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

• SAP Service Cloud v2
• SAP Sales Cloud v2

1. Click on the profile button.
2. Select Settings.
3. Go to All settings.
4. Open Import and Export Data screen.
5. Click on the import button.
6. Fill the details and click on import.
7. You will receive the error: "{Entity Name}: Invalid date value in field {field name} in row {X}, externalId {Y}. The expected date format is YYYY-MM-DD." or "{Entity Name}: Invalid date value in field {field name} in row {X}. The expected date format is YYYY-MM-DD'T'HH:mm:ss'Z'."
8. Note: This error can occur with any entity which has date fields.

Incorrect format for date/timestamp fields.

• For date fields (e.g. "Valid From" or "Valid To") the date should be in the format YYYY-MM-DD (year-month-day). For example, 2015-11-25. 
• To import a timestamp field, use format YYYY-MM-DD:mm:ssZ. For example, 2021-12-31T23:59:59Z. Enter the UTC time.

Also, for the data to get saved correctly in the CSV or Excel, please make sure the date or timestamp fields have the type of Text. This way, the information will get stored in the correct format.

Help Documentation: Prepare Data

Invalid date, Data Import, Format, Excel, CSV , KBA , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , How To