Symptom
- Different report formats (Excel and CSV) display inconsistent class start and end dates for the same class in Canvas LMS reports.
- When exporting as CSV format, the date is consistent with the actual date data (ex. 12/10/2025 Oct.12th 2025) in Learning. While exporting as Excel (xlsx) , the date (10/12/2025, Dec.10th 2025) is wrong.
- The issue only happening for date in Oct, Nov, and Dec.
- In Excel sheet file, some date data is shown as cell format "Text", while some date data is shown as cell format "Date".
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
- SAP SuccessFactors Learning
- SAP SuccessFactors People Analytics
Product
SAP SuccessFactors Learning all versions
Keywords
SAP SuccessFactors, Canvas report, LMS, Learning Data, Date format mismatch, Class start date, Class end date, Export issue, Excel, Inconsistent dates, Bizx user locale, LMS administrator settings, Date, Text, Cell format , KBA , LOD-SF-LMS-REP , Reporting Data , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview