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
- Open MS Excel and go to the Addin tab.
- Login to your tenant with your user credentials and password.
- Click Insert Report.
- 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).
- Insert the report.
- 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