topic Date issue with Excel Export in QlikView https://community.qlik.com/t5/QlikView/Date-issue-with-Excel-Export/m-p/82187#M13497 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have written a function to load only Jan 2017, feb 2017, jan 2018, feb 2018 from my QVD, I get correct result.</P><P>But after adding all the columns in table box&nbsp; when I export , I get extra date appearing in the excel other than Jan and Feb. How to resolve this?</P></BODY></HTML> Mon, 11 Jun 2018 11:01:48 GMT Anonymous 2018-06-11T11:01:48Z Date issue with Excel Export https://community.qlik.com/t5/QlikView/Date-issue-with-Excel-Export/m-p/82187#M13497 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have written a function to load only Jan 2017, feb 2017, jan 2018, feb 2018 from my QVD, I get correct result.</P><P>But after adding all the columns in table box&nbsp; when I export , I get extra date appearing in the excel other than Jan and Feb. How to resolve this?</P></BODY></HTML> Mon, 11 Jun 2018 11:01:48 GMT https://community.qlik.com/t5/QlikView/Date-issue-with-Excel-Export/m-p/82187#M13497 Anonymous 2018-06-11T11:01:48Z Re: Date issue with Excel Export https://community.qlik.com/t5/QlikView/Date-issue-with-Excel-Export/m-p/82188#M13498 <HTML><HEAD></HEAD><BODY><P>Try this...</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Go to document properties - Numbers.You will find all the dimensions listed on the left.Select your required dimension from the left. And give it the desired format from the right.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">This should work.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Regards,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Mayank</P></BODY></HTML> Mon, 11 Jun 2018 11:30:07 GMT https://community.qlik.com/t5/QlikView/Date-issue-with-Excel-Export/m-p/82188#M13498 mayankraoka 2018-06-11T11:30:07Z