SAP Knowledge Base Article - Public

3399428 - Error “Invalid Date Value” When Importing Data

Symptom

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. 

Environment

  • SAP Service Cloud v2
  • SAP Sales Cloud v2

Reproducing the Issue

  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.

Cause

Incorrect format for date/timestamp fields.

Resolution

  • 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.

See Also

Help Documentation: Prepare Data

Keywords

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

Product

SAP Sales Cloud and SAP Service Cloud Version 2 1.0

Attachments

DateField.png
Pasted image.png