I work for Woodgroup PSN contracted to Shell so I’m using the SAP system as a third party user.
The issue I'm having is exporting spreadsheets in to Excel from SAP, all the data comes across OK but some of the dates come over as UK date format and some come over as US date format. I am then unable to filter the column with the LAFD (last alowable finish dates) in Excel because of the mix of UK and US date formats.
The only way to do it is by going and changing each individual daye that has an american format, its not even possible to click on the colomn and format cell properites to arrange tham all as UK data format.
I am using IW38 - Change PM Work Orders
Hope someone can help