SAP Knowledge Base Article - Public

2899098 - Incorrect CET Time is Updated for Appointments When Uploading via Data Workbench


You see that the start/end dates are taken incorrectly when you have uploaded the appointments using data workbench for CET timezone.


SAP Cloud for Customer

Reproducing the Issue

  1. Go to Data Workbench workcenter
  2. Go to Import view
  3. Select Insert
  4. Select Standard Object Appointment
  5. Select Download Template
  6. Update the values for Start Date and End Date

Once the data is inserted, you will see that the uploaded time is ahead by two hours in your system despite of correct personalized settings


Data Workbench only takes UTC as the standard input time and CET is UTC+1. Nevertheless, during summer time in Europe, clocks are advanced by one hour from the time observed in the rest of the year. Typically, European summer time begins at 01:00 UTC/WET (02:00 CET, 03:00 EET) on the last Sunday in March and ends at 01:00 UTC (02:00 WEST, 03:00 CEST, 04:00 EEST) on the last Sunday in October each year.

This results in addition of an extra hour than the actual CET time.


This is the designed system behavior and users have to ensure that the time uploaded during European summer time should be entered by reducing 2 hours, so that it reflects the actual time once it is uploaded.

See Also

1686033 - How to Change the Time Zone of Customer System

2461362 - Imported Visits Have Different Times And Dates Than Set in Data Workbench Template


Data Workbench, Activities, Appointments, Insert, Time Zone , KBA , data workbench , activities , appointments , time zone , insert , summer time , utc , cet , LOD-CRM-ACT , Activities , LOD-CRM-INT-DWB-API , Data workbench API , LOD-CRM-INT-DWB , Data Workbench , How To


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