topic Date fields when sent to Excel are not correctly formatted in QlikView https://community.qlik.com/t5/QlikView/Date-fields-when-sent-to-Excel-are-not-correctly-formatted/m-p/160305#M34627 <HTML><HEAD></HEAD><BODY><P>Hi !</P><P>I have this small QVW where a Date field (DATE_TEST) is shown on several objects.</P><P>For any of those objects, when I export them to Excel, I have the Date not correctly formatted in Excel. I have to fix the formatting manually in Excel. Then I can see the correct date.</P><P>Have I made something wrong or is this a bug ?</P><P>Thanks !</P><P></P></BODY></HTML> Thu, 25 Feb 2010 19:35:05 GMT 2010-02-25T19:35:05Z Date fields when sent to Excel are not correctly formatted https://community.qlik.com/t5/QlikView/Date-fields-when-sent-to-Excel-are-not-correctly-formatted/m-p/160305#M34627 <HTML><HEAD></HEAD><BODY><P>Hi !</P><P>I have this small QVW where a Date field (DATE_TEST) is shown on several objects.</P><P>For any of those objects, when I export them to Excel, I have the Date not correctly formatted in Excel. I have to fix the formatting manually in Excel. Then I can see the correct date.</P><P>Have I made something wrong or is this a bug ?</P><P>Thanks !</P><P></P></BODY></HTML> Thu, 25 Feb 2010 19:35:05 GMT https://community.qlik.com/t5/QlikView/Date-fields-when-sent-to-Excel-are-not-correctly-formatted/m-p/160305#M34627 2010-02-25T19:35:05Z Date fields when sent to Excel are not correctly formatted https://community.qlik.com/t5/QlikView/Date-fields-when-sent-to-Excel-are-not-correctly-formatted/m-p/160306#M34628 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>If you set the format for the field under Document properties (Ctrl+Alt+D), the tab "Number" and select Date for the DATE_TEST-field it should work.</P><P>/Fredrik</P></BODY></HTML> Thu, 25 Feb 2010 19:50:48 GMT https://community.qlik.com/t5/QlikView/Date-fields-when-sent-to-Excel-are-not-correctly-formatted/m-p/160306#M34628 2010-02-25T19:50:48Z