SAP Knowledge Base Article - Public

2930826 - The Value Of The Field 'Start Date *' Is Invalid Is Faced During Excel Upload

Symptom

 You are trying to upload Leads using the Microsoft Excel Upload feature but face an error.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Marketing Work center.
  2. Go to Leads view.
  3. Click on New -> Leads from Microsoft Excel.
  4. In the Excel, fill in the details.
  5. Log in to the system and click on Save Data To.

ErrorRow -The value 'DD.MM.YYYY' of the field 'Start Date *' is invalid.

ErrorRow -The value 'DD.MM.YYYY' of the field 'End Date *' is invalid.

Cause

The date format entered does not match what needs to be used. The value is not being considered as a date. eg. DD.MM.YYYY -> You can notice that this value does not get converted to a date value.

Resolution

When modifying the value to be eg. DD-MM-YYYY, Excel will take this as a date format and convert to a date value. Hence, use the date format as DD-MM-YYYY and not as DD.MM.YYYY.

Keywords

"Leads", "Excel", "Upload" , KBA , opportunity , leads , excel upload , SRD-CRM-OPP , Opportunities , Problem

Product

SAP Business ByDesign all versions