topic Send to Excel date format inconsistency in QlikView https://community.qlik.com/t5/QlikView/Send-to-Excel-date-format-inconsistency/m-p/291764#M583974 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;">I have two objects with the exact same data.&nbsp; One is a combo chart, the other a straight table.&nbsp; </SPAN><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;">When I “send to excel” each object, the straight table retains its date format (Sep 2011).&nbsp; However, the combo chart date changes to a numeric format (40787).&nbsp; </SPAN></P><P><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;"> </SPAN></P><P><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;">Aside from formatting the date as text, how do I retain the correct date format with the combo chart?&nbsp; Why does this work properly for one object and not another?&nbsp; Perhaps a bug?</SPAN></P></BODY></HTML> Wed, 02 Nov 2011 15:58:07 GMT BarbCline 2011-11-02T15:58:07Z Send to Excel date format inconsistency https://community.qlik.com/t5/QlikView/Send-to-Excel-date-format-inconsistency/m-p/291764#M583974 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;">I have two objects with the exact same data.&nbsp; One is a combo chart, the other a straight table.&nbsp; </SPAN><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;">When I “send to excel” each object, the straight table retains its date format (Sep 2011).&nbsp; However, the combo chart date changes to a numeric format (40787).&nbsp; </SPAN></P><P><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;"> </SPAN></P><P><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;">Aside from formatting the date as text, how do I retain the correct date format with the combo chart?&nbsp; Why does this work properly for one object and not another?&nbsp; Perhaps a bug?</SPAN></P></BODY></HTML> Wed, 02 Nov 2011 15:58:07 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-date-format-inconsistency/m-p/291764#M583974 BarbCline 2011-11-02T15:58:07Z Send to Excel date format inconsistency https://community.qlik.com/t5/QlikView/Send-to-Excel-date-format-inconsistency/m-p/291765#M583975 <HTML><HEAD></HEAD><BODY><P>Assuming this is WAD and will change my date format to force the text formatting when data is sent to excel.&nbsp; </P><P>text(MonthName(Date)) </P></BODY></HTML> Wed, 09 Nov 2011 16:59:26 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-date-format-inconsistency/m-p/291765#M583975 BarbCline 2011-11-09T16:59:26Z