SAP Knowledge Base Article - Public

2744758 - Incorrect date shown in Integration Center

Symptom

  • The incorrect date is shown in the integration center compared to date selected in the UI e.g. job start date on an application.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SuccessFactors Recruiting Management (RCM)
  • SuccessFactors HXM Suite
    • Integration center

Reproducing the Issue

  1. Select a date on an application e.g. 01/31/2019 for field job start date
  2. In the integration center create an outbound integration
  3. Create a report including this field
  4. In the integration center the date appears as 30/01/2019

Cause

This is an expected behavior. Integration Center displays the date time values in UTC timezone for all outbound integrations. Let us consider an example where the server timezone is UTC+1 and the datetime value of the Start Date field is 2018-31-01 00:00:00 UTC+1. Integration Center displays the datetime as 2018-01-30T23:00:00Z, which is
the value of the Start Date field in the UTC timezone.

Resolution

This expected behavior of the system. However there is a workaround to display the date the same as the UI. Follow the steps below:

  1.  In the report, go to configure fields.
  2. Select the date field to display dropdown.
  3. Click on "edit calculation".
  4. Select date.
  5. Add + or - depending on time difference between server and UTC.
  6. Add the number of hours to display correct date in UTC e.g. 1 for UTC +1.
  7. Select unit of time "H" for hours.
  8. Adding one hour, the time will now display as 01/31/2019 00:00:00z in the integration center.

Please note to avoid potential issues with daylight savings it may be necessary to add an extra few hours in the number of units column within the simple calculation window.

edit caculation in IC.png

add h to IC.png

Keywords

Integration center date, incorrect date, incorrect date in integration center, time stamp, UTC, timezone , KBA , LOD-SF-INT-INC-JOB , Integration Center Job , LOD-SF-INT , Integrations , LOD-SF-RCM , Recruiting Management , LOD-SF-INT-INC , Integration Center , Problem

Product

SAP SuccessFactors HCM suite all versions ; SAP SuccessFactors Recruiting all versions