How to set date format for export to Excel so it shows the same in different countries and not change due to computer regional settings
Hi
First time here so I hope you can help. I hope that this is the correct place to add this question.
I'm not the QlikView product manager but the Office configuration owner. Key users of QlikView are complaining that the column with dates in is showing different date format depending on the regional date settings.
Is there a way that the export of reports to Excel can be set say to one date format for example 7 January 2021 and this format will show in the same way in any other country and not change to another language, for example French (7 janvier 2021? I am trying to make it easier for the user instead of them changing the format manually each time.
As I said I am not very familiar with Qlikview so I hope you can help. We are apparently using Qlikview October.
