Symptom
Dates in Integration Center are displayed as 1 day before the dates visible in Recruiting (i.e. Job Start Date in the job Requisition Details page).
Environment
SAP SuccessFactors Recruiting Management
Reproducing the Issue
- In the Job Requisition Details page the Job Start Date is 2021-10-01
- Go to Integration Center
- Run a report on Job Start Date
- The date visible in Integration Center is 2021-09-30 (1 day before)
Cause
This is caused by different timezone between the server and Integration Center.
Resolution
In general, all dates in Recruiting are stored in server timezone. While fetching using OData, it is converted to UTC:
Job Start Date in UTC : 2021-09-30 22:00:00 UTC (https://savvytime.com/converter/cest-to-utc/oct-1-2021/12am) which is what is seen in Integration Center. This is as expected.
To get back the original date values, these dates need to be converted back to the server timezone, i.e. CEST/CET.
Also please note the following: Central European Time.
"As of 2011, all member states of the European Union observe summer time (daylight saving time), from the last Sunday in March to the last Sunday in October. States within the CET area switch to Central European Summer Time (CEST -- UTC+02:00) for the summer".
Therefore the difference of 1 or 2 hours depends on the date value, depending on whether day light saving is enabled or not during that time.
PLEASE NOTE: Currently all SuccessFactors datacenters are moving to the UTC time zone. As a result, this behavior will be corrected so the Integration Center dates will be the same as what is shown in the UI.
Please review the dates in the following KBA to see when these changes will be effective in your Data Centers:
3140223 - FAQ: SuccessFactors DataCenter time Zone as UTC
See Also
2933028 - Using the DateTimeOffset and DateTime Formats - OData API
2429986 - Jobs and Reports generated on different timezones
3140223 - FAQ: SuccessFactors DataCenter time Zone as UTC
Keywords
Timezone, Date, Start, Date, Integration, Center, Difference, Server, DateTimeOffset, Migration, UTC. , KBA , LOD-SF-RCM-INT , Integration Center & Intelligent Services , Problem