Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

alkesh_sharma
Contributor II

Exporting to Excel changes Date format to Text String??

Hello Experts,

I am facing an issue since yesterday. One of my reports have date columns and are in format 'DD-MM-YYYY' but when this reported is exported to excel the date is converted to Text string, which makes it unusable for further calculations.

I have tried every possible way which i could think of and I am sure that this is a bug. I want a confirmation from you guys.

Thanks,

Alkesh

1 Solution

Accepted Solutions
vivek_niti
Contributor

Re: Exporting to Excel changes Date format to Text String??

this is a bug in this version.

upgrade to QV 11.2SR9.

Regards,

7 Replies
amit_saini
Honored Contributor III

Re: Exporting to Excel changes Date format to Text String??

Re: Exporting to Excel changes Date format to Text String??

Hi,

Go to Help tab->Click on About Qlikview (You get new window)->right click on Qlikview Icon (left bottom)->You get setting window->select ExcelExportMixedAsText->set its value to 0 from 1

Regards

Regards,
Prashant Sangle
alkesh_sharma
Contributor II

Re: Exporting to Excel changes Date format to Text String??

Tried, but not working.

alkesh_sharma
Contributor II

Re: Exporting to Excel changes Date format to Text String??

This was the very first thing I tried, not working

vivek_niti
Contributor

Re: Exporting to Excel changes Date format to Text String??

which QV Version are you using?

alkesh_sharma
Contributor II

Re: Exporting to Excel changes Date format to Text String??

Hello Vivek

Its, Version 11.0 SR2.

vivek_niti
Contributor

Re: Exporting to Excel changes Date format to Text String??

this is a bug in this version.

upgrade to QV 11.2SR9.

Regards,

Community Browser