2343660 - Adhoc Report date difference by 1 day

SAP Knowledge Base Article - Public

2343660 - Adhoc Report date difference by 1 day

Symptom

Adhoc Report showing 1 day (plus/minus) date difference than actual data in the Bizx instance.

 

Environment

SAP Successfactors

Adhoc Report

Reproducing the Issue

Note the date in the system. Example: Start date of work experience in Employee Profile.

4.PNG

Adhoc Report is showing the date 1 day before the actual date.

1.PNG

Cause

We have a setting in Adhoc Report to convert the date/timestamp to the timezone of the logged in user (localized )running the report rather than the server time.

If the setting is enabled then the difference in the date in expected.

  1. Edit the Adhoc Report and go to Configuration tab.
  2. Click DataType Configuration and see if "Localized" setting is checked/unchecked.

2.PNG

 

3. Uncheck the option and run the report again. You will see the same date as in instance.

3.PNG

Keywords

Adhoc Report 1 day date difference Localized , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem

Product

SAP SuccessFactors Workforce Analytics all versions