SAP Knowledge Base Article - Public

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

Symptom

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).

Environment

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.

Cause

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.

Resolution

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

Keywords

incorrect, wrong, automatically, automatic, import, migration , KBA , LOD-CRM-INT-DWB , Data Workbench , LOD-LE-MKT-LEA , Lead , Problem

Product

SAP Cloud for Customer add-ins all versions