topic Date Format issues when exporting to data to Excel in QlikView https://community.qlik.com/t5/QlikView/Date-Format-issues-when-exporting-to-data-to-Excel/m-p/251589#M95434 <HTML><HEAD></HEAD><BODY><P>Hi rajesh</P><P>Please can you attach to see what is the problem?</P><P></P><P>Regards</P></BODY></HTML> Tue, 07 Feb 2012 13:15:14 GMT Anonymous 2012-02-07T13:15:14Z Date Format issues when exporting to data to Excel https://community.qlik.com/t5/QlikView/Date-Format-issues-when-exporting-to-data-to-Excel/m-p/251588#M95433 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have an application where I have functionality to export my objects and data to Excel using a button. I am trying to export a table with Calendar dates and when I export them the date format is wrong. I am after the date format 'DD/MM/YYYY' but whenever I export data the format is DD/MMYYYY in some cases and then MM/DD/YYYY, exporting extra lines from what I wish to export. </P><P></P><P>Will I need to something in my macro so that whenever I export data the format is the correct date format? </P><P>Is this a user Excel issue? </P><P></P><P>Any ideas. </P><P></P><P>Thanks</P></BODY></HTML> Fri, 03 Feb 2012 11:43:08 GMT https://community.qlik.com/t5/QlikView/Date-Format-issues-when-exporting-to-data-to-Excel/m-p/251588#M95433 2012-02-03T11:43:08Z Date Format issues when exporting to data to Excel https://community.qlik.com/t5/QlikView/Date-Format-issues-when-exporting-to-data-to-Excel/m-p/251589#M95434 <HTML><HEAD></HEAD><BODY><P>Hi rajesh</P><P>Please can you attach to see what is the problem?</P><P></P><P>Regards</P></BODY></HTML> Tue, 07 Feb 2012 13:15:14 GMT https://community.qlik.com/t5/QlikView/Date-Format-issues-when-exporting-to-data-to-Excel/m-p/251589#M95434 Anonymous 2012-02-07T13:15:14Z