SAP Knowledge Base Article - Preview

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. 


Read more...

Environment

  • SAP Service Cloud v2
  • SAP Sales Cloud v2

Product

SAP Sales Cloud and SAP Service Cloud Version 2 1.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.