Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
duschking
New Contributor

Date export to excel Wrong DD.MM.YYYY -> MM.DD.YYYY

hi.

we have been exporting data to excel since qlikview is installed.

the export always went ok.

but about 1 week ago the date format is wrong in excel in every document.

in qlikview the format is

DD.MM.YYYY

and excel shows

MM.DD.YYYY

we changed nothing - neither the server nor the client.

i tryed client V11R14 and V12R5 and the windows link..

it happens on every plattform

pls help..

3 Replies
Chanty4u
Esteemed Contributor III

Re: Date export to excel Wrong DD.MM.YYYY -> MM.DD.YYYY

try in SET Dateformat='DD.MM.YYYY';

gferran
New Contributor III

Re: Date export to excel Wrong DD.MM.YYYY -> MM.DD.YYYY

you can use in the scrip editor:

Date(FIELD,'DD/MM/YYYY')     AS MyFIELD

Regards

duschking
New Contributor

Re: Date export to excel Wrong DD.MM.YYYY -> MM.DD.YYYY

>>try in SET Dateformat='DD.MM.YYYY';

this is already in the script.


we got 100s of documents. it always worked and i dont want to change 100s of documents..