topic Re: Date export to excel Wrong DD.MM.YYYY -> MM.DD.YYYY in App Development

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

duschking — Thu, 15 Sep 2016 12:34:34 GMT

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

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

Chanty4u — Thu, 15 Sep 2016 16:57:07 GMT

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

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

gferran — Thu, 15 Sep 2016 17:13:55 GMT

you can use in the scrip editor:

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

Regards

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

duschking — Fri, 16 Sep 2016 11:14:46 GMT

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

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

vinesh_panchal — Tue, 03 Sep 2019 14:00:33 GMT

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

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

mahaveerbiraj — Tue, 03 Sep 2019 17:41:12 GMT

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.