1599577 - The Last Updated Date and Time is not the correct one when using Export to Excel functionality.

SAP Knowledge Base Article - Public

1599577 - The Last Updated Date and Time is not the correct one when using Export to Excel functionality.

Symptom

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

Reproducing the Issue

1. From the Application & User Management work center choose the User and Access Management view.
2. 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.

Cause

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

Resolution

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 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.



Keywords

KBA , SRD-MD-PRD-PRD , Product , How To

Product

SAP Business ByDesign all versions