SAP Knowledge Base Article - Public

2786326 - Date field value has difference of one day in ORD than in LMS - Online Report Designer

Symptom

Date field value has a difference of one day in ORD report than in LMS e.g. Assignment Date from Learning History

Environment

  • SAP SuccessFactors Learning 
  • SAP SuccessFactors HCM Suite
    • Online Report Designer / Report - Canvas

Reproducing the Issue

  1. Create an ORD report and select the LMS domain
  2. Select Learning Item Assignment and History table
  3. Select the date field "Assignment Date"
  4. Run the report and check that the date value is not matching the same value from LMS module
  5. There is a difference of one day

Cause

Assignment Date field is stored in the database in UTC timezone and when extracted via ORD, it is converted to the user's timezone.

For example, the date value (timestamp) from the server can be 2/2/2019 (12AM - UTC), but the user will see the date as 2/1/2019 (8PM - EST) in the ORD report.

Resolution

This is an expected behavior.
The Assignment Date field from the LMS domain in ORD is localised (user's timezone) but in LMS it is available in UTC timezone.

If you feel the feature is important, we request you to submit an enhancement request for the same.
2090228 - How to submit enhancement requests for SAP SuccessFactors products
This will allow other customers to vote up and thereby express their interest on the same.
Our Product management teams review enhancement requests regularly and implement them if and when feasible.

Keywords

Date, field, value, difference, of, one, day, in ,ORD, report, than, in, LMS, Assignment, from, Learning, History , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors HXM Suite all versions ; SAP SuccessFactors Learning all versions