You are trying to upload Leads using the Microsoft Excel Upload feature but face an error.
SAP Business ByDesign
Reproducing the Issue
- Go to the Marketing Work center.
- Go to Leads view.
- Click on New -> Leads from Microsoft Excel.
- In the Excel, fill in the details.
- 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