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

danxavyS — Sat, 16 Nov 2024 00:51:31 GMT

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.

Best regards

Dan Smith

Re: 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

Ksrinivasan — Thu, 07 Jan 2021 13:55:02 GMT

hi,

ConvertToLocalTime(timestamp [, place [, ignore_dst=false]])

use this link:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/converttolocaltime.htm

topic Re: 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 in App Development

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

Re: 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