2786326 - Online Report Designer - Date value has difference of one day when comparing with Learning

When comparing the data between Learning reports and the data fetched by Canvas report (ORD), there is a difference of one day in some date fields like assignment date, etc.

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

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 Learning side, there is a difference of one day.

Certain learning fields, such as assignment date, are stored in the database in UTC timezone and when extracted via Canvas Online Report (ORD), it is converted to the user's timezone managed in the UDF file.

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

This is an expected behavior.

The Assignment Date field from the Learning domain in ORD is localised (user's timezone in UDF file) but in Learning it is available in UTC timezone.

If changing this system behaviour is an important topic to your company, we request you to submit an enhancement request for the same. Refer to the KBA 2090228 - How to submit enhancement requests for SAP SuccessFactors products.

SuccessFactors, Learning, Analytics, ORD, Online Report Designer, Date, field, value, difference, LMS, Assignment, Learning History. , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-LMS-REP , Reporting Data , Problem

SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors Learning all versions