SAP Knowledge Base Article - Public

3639082 - Invalid values for "Start Date/Time" and "End Date/time" for visits marked as "all-day event" during data export

Symptom

Visits marked as "All-day event" are showing discrepancies in "Start Date/Time" and "End Date/time" values when exported via Data Workbench.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Navigate to Data Workbench and select the "Export" option.
  2. Choose the "Standard Object > Visit" option.
  3. Export the data and review the Start_DateTime and End_DateTime values in the exported file.
  4. See that random values are appearing for those fields for Visits set as "All-day event", which should not be time-relevant.

Cause

As per the current design, system records the time of creation as the Start_DateTime and the end of the day as the End_DateTime for visits marked as "All-day event". These values are not visible in the Visit Overview but are displayed in the Data Workbench export.

Resolution

This is the expected system behavior.

See Also

Refer to KBA 3004053  - Cannot make Start Date and End Date Visible On Visit Or Appointment for additional details on the behavior of "All-day event" visits.

Keywords

all-day event, Start Date/Time, End Date/time, data workbench, start datetime, end datetime, mismatch, dwb , KBA , LOD-CRM-ACT-VST , Visit Planning , Problem

Product

SAP Cloud for Customer core applications all versions