topic Datetime export to excel rounding problem in QlikView https://community.qlik.com/t5/QlikView/Datetime-export-to-excel-rounding-problem/m-p/622248#M229051 <HTML><HEAD></HEAD><BODY><P>Hi Qlik-community,</P><P></P><P>See attached, I experience strange behavior and hope you have some advice on how to handle this.</P><P></P><P>The .qvw explains it all, but here I :</P><P>- I have a datetime in Qlikview like 28-2-2014 23:59:59</P><P>- When I export it to Excel, it is shown as 1-3-2014 0:00:00</P><P></P><P>It seems that some rounding was done, but this is not what I want.</P><P></P><P>How can I make sure that Excel presents exactly what is exported from Qlikview?</P><P></P><P>Thanks in advance!</P><P></P><P>Roberto&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 26 Mar 2014 08:39:45 GMT 2014-03-26T08:39:45Z Datetime export to excel rounding problem https://community.qlik.com/t5/QlikView/Datetime-export-to-excel-rounding-problem/m-p/622248#M229051 <HTML><HEAD></HEAD><BODY><P>Hi Qlik-community,</P><P></P><P>See attached, I experience strange behavior and hope you have some advice on how to handle this.</P><P></P><P>The .qvw explains it all, but here I :</P><P>- I have a datetime in Qlikview like 28-2-2014 23:59:59</P><P>- When I export it to Excel, it is shown as 1-3-2014 0:00:00</P><P></P><P>It seems that some rounding was done, but this is not what I want.</P><P></P><P>How can I make sure that Excel presents exactly what is exported from Qlikview?</P><P></P><P>Thanks in advance!</P><P></P><P>Roberto&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 26 Mar 2014 08:39:45 GMT https://community.qlik.com/t5/QlikView/Datetime-export-to-excel-rounding-problem/m-p/622248#M229051 2014-03-26T08:39:45Z