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

[duschking]

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

[Chanty4u]

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

[gferran]

you can use in the scrip editor:

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

Regards

[duschking]

>>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]

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]

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.