SAP Knowledge Base Article - Preview

3711790 - Incorrect date, time and datetime format in Excel exports - SAPUI5

Symptom

  • Incorrect date format observed in Excel exports after SAP S/4HANA Cloud Public Edition 2602 upgrade.
  • Incorrect date format observed with SAPUI5 1.138 - 1.144
  • The problem occurs when the date, time, datetime patterns are customized (user settings) and the customization differs from the default settings for the user locale. E.g. if a user has a German locale and the customization defines the format YYYY-MM-DD 

For example:

  • Date format is configured in the User Profile settings as dd.mm.yyyy.
  • Date format is displayed in the applications as dd.mm.yyyy.
  • The date format in the exported Excel files display dates as m.dd.yy.


Read more...

Environment

SAP S/4HANA Cloud Public Edition 2602

SAP Fiori Launchpad

SAP Build Work Zone

SAPUI5 1.138 - 1.144

Product

SAP Build Work Zone, advanced edition all versions ; SAP Fiori all versions ; SAP S/4HANA Cloud Public Edition 2602

Keywords

excel export, incorrect date format, ce2602 update, dd.mm.yyyy, m.dd.yy, SAPUI5, regression issue, date format settings, SAP S/4HANA Cloud, 2602, SAPUI5, 1.138, 1.144, user profile, language settings, date format , KBA , CA-UI5-TBL , SAP UI5 table, smart table, list and tree controls , 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.