topic Date loading wrong from XLS file but correct from XLSX file in QlikView https://community.qlik.com/t5/QlikView/Date-loading-wrong-from-XLS-file-but-correct-from-XLSX-file/m-p/312516#M115409 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>First week with QV and first post which makes me wonder if I've search enough before post, but I guess yes.</P><P></P><P>I load an excel file containting a date (MVT_DATE)as a time stamp. I can play with it in excel with =month() formula or so.</P><P>When I import the date filed into QV, QV seems to change the date change the date from something like Dec 28, 2011 to March, 03 2007.</P><P></P><P>This is not the case if I convert source excel file to XLX file. With an XLX file the date is imported accurately!</P><P></P><P>Did I missed something ?</P><P></P><P></P><P>Excel : Windows 2003.</P><P>QV : 10,00,9277,8</P><P></P><P>Tanguy</P></BODY></HTML> Fri, 27 Jan 2012 11:05:03 GMT 2012-01-27T11:05:03Z Date loading wrong from XLS file but correct from XLSX file https://community.qlik.com/t5/QlikView/Date-loading-wrong-from-XLS-file-but-correct-from-XLSX-file/m-p/312516#M115409 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>First week with QV and first post which makes me wonder if I've search enough before post, but I guess yes.</P><P></P><P>I load an excel file containting a date (MVT_DATE)as a time stamp. I can play with it in excel with =month() formula or so.</P><P>When I import the date filed into QV, QV seems to change the date change the date from something like Dec 28, 2011 to March, 03 2007.</P><P></P><P>This is not the case if I convert source excel file to XLX file. With an XLX file the date is imported accurately!</P><P></P><P>Did I missed something ?</P><P></P><P></P><P>Excel : Windows 2003.</P><P>QV : 10,00,9277,8</P><P></P><P>Tanguy</P></BODY></HTML> Fri, 27 Jan 2012 11:05:03 GMT https://community.qlik.com/t5/QlikView/Date-loading-wrong-from-XLS-file-but-correct-from-XLSX-file/m-p/312516#M115409 2012-01-27T11:05:03Z