SAP Knowledge Base Article - Public

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


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


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.


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.


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.


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


SAP Business ByDesign all versions