SAP Knowledge Base Article - Public

2798722 - Start Date and End Date Getting Fillled With Default Values When Inserting Lead Using Data Workbench


You upload a lead using Data Workbench and you notice that the START_DATE and the END_DATE are filled with default values (START_DATE = current date, END_DATE = current date + 1 month).


SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Data Workbench work center.
  2. Select the Import tab.
  3. Select Insert.
  4. Search for object: Lead.
  5. Select Next to perform the import.


Your entries in the START_DATE and the END_DATE fields of the csv file are only considered, when both fields are filled.

When either the start date is empty or the end date is empty in the CSV file, then both dates are filled with the default values: START_DATE = current date, END_DATE = current date + 1 month.


Maintain START_DATE as well as END_DATE to ensure that the lead has the expected values.


incorrect, wrong, automatically, automatic, import, migration , KBA , data workbench , import , start date , end date , insert , lead , LOD-CRM-INT-DWB , Data Workbench , LOD-LE-MKT-LEA , Lead , Problem


SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions