SAP Knowledge Base Article - Preview

2498557 - Date format is inconsistent between CSV exports from Table reports / Canvas reports

Symptom

  • While exporting Ad Hoc / Table reports in CSV format (online or offline runs), the date format is not displayed properly in Microsoft Excel. However, exports in XLS and XLSX display the dates in the expected format.
  • Leading zeros are not showing correctly on the dates for report extract.

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 HXM Suite
  • Report Table
  • Report Canvas

Product

SAP SuccessFactors HCM Suite all versions

Keywords

CSV, date, format, inconsistent, locale, Ad, Hoc, report, table, center, excel, xls, xlsx, yyyy, mm, dd

, KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , 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.