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
- Click on the profile button.
- Select Settings.
- Go to All settings.
- Open Import and Export Data screen.
- Click on the import button.
- Fill the details and click on import.
- 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'."
- 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
Attachments
DateField.png |
Pasted image.png |