Date format issues when exporting to a non-USA excel
Has anyone else had an issue with non-US users not being able to sort the excel date fields that come for the export to excel option on the reports. I have a German user who gets the date formatted in MM/DD/YYYY from archer to excel and even changes the column to the date format in excel but when they sort or filter it is not recognizing the date. It works fine for me in the US version of Excel.
It sounds like a problem outside of Archer (maybe Excel itself?). However, if you are able to reproduce consistently I recommend raising a case with support with the details unless someone else has already seen this issue and has a quick fix. A sample of the excel will be helpful.
Try the following steps to troubleshoot and isolate the issue:
- Can the troubled user reproduce the issue in multiple environments?
- If the troubled user logs into Archer from another workstation, does the issue occur? If not, this points to a problem on the troubled user's workstation or Excel.
- Do other German users have the issue performing the same steps as the troubled user?
- If the troubled user sends the Excel file to another German user, does the issue occur?