SAP Knowledge Base Article - Public

2967064 - Date Format Changes When Opening Reports From The Excel Add-In


You opened a report via the MS Excel Add-in and noticed that the date format changes for some entries.


  • SAP Business by Design
  • SAP Cloud for Customer

Reproducing the Issue

  1. Open MS Excel and go to the Add-in tab.
  2. Log-in to your tenant with your user credentials and password.
  3. Click Insert Report.
  4. Search for the report view you would like to open via the Excel Add-in (for example a view from standard report User Logon Details technical ID CCARUSRLOG).
  5. Insert the report.
  6. You will notice that the column for characteristic Last Logon Date - UTC will display different date formats.


This behavior occurs if your SAP Cloud for Customer user settings do not match with your maintained windows settings for the date format.


Please make sure you are using the same date format in your Cloud for Customer system and windows settings. For example if C4C is showing format DD.MM.YYYY under my settings please make sure that windows is using the same format. Please notice that the available date formats in windows are depending from your regional settings.

See Also

Our development team will try to fix this behavior in future releases.


Excel Add-in; date format; wrong format; incorrect date; incorrect format; , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions