SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • SAP Business by Design
  • SAP Cloud for Customer

Reproducing the Issue

  1. Open MS Excel and go to the Addin tab.
  2. Login 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 Addin (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.

Cause

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

Resolution

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 behaviour in future releases.

Keywords

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

Product

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