Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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..

5 Replies
Chanty4u
Esteemed Contributor III

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

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

Highlighted
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..

vinesh_panchal
New Contributor II

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

Hi Duschking, 

 

I've had this issue to, so i'm copying it from DD.MM.YYYY and its pasting it into excel as MM.DD.YYYY, so my solution was to turn the original source of where its copying from to convert that to MM.DD.YYYY and then when thats pasted into Excel it'll turn into DD.MM.YYYY. 

This is how I've got around it, no idea why i have to do that but it works for me.

 

thanks


Vinesh

mahaveerbiraj
Contributor II

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

Hi. 

May be this is help to you resolve the issue 

Go settings menu and document settings in number tab change that field format to your required format.

All the best.