SAP Knowledge Base Article - Public

1599577 - The Last Updated Date and Time is not the Correct One When Using Export to Excel Functionality


Using the Export to Excel functionality the Date and Time in the report does not match the local Time.


SAP Business by Design

Reproducing the Issue

1. From the Application & User Management work center choose the User and Access Management view.
2. Go to the Business Users sub view.
3. Highlight a User and choose Export to Excel.
4. The Last Updated On field shows a Date and time which doesn't correspond to the actual one.


The last update Date and Time, on the spreadsheet, is filled with the timezone set by the logged in User.


In order to have the correct Date and Time shown you must make sure that the User Regional Settings are set as follow:

1. Go to the Home work center.
2. From the menu, select Personalize then My Settings.
3. Choose the Regional Settings tab.
4. Change the Time Zone based on your requirement.
5. Re-login.
6. If you try to export the User to Excel you should get the local Date and Time.


Last updated on; business user; local settings; export to excel; my settings; user regional settings , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


SAP Business ByDesign all versions