topic datetime field is displaying decimal data while loading qvd in QlikView https://community.qlik.com/t5/QlikView/datetime-field-is-displaying-decimal-data-while-loading-qvd/m-p/501183#M187275 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have date fieldname having datetime datatype but when I load qvd data is dilsplaing with decimals not in date format.</P><P>how i load this data.<A href="https://community.qlik.com/qlik-users/1">Administrator</A></P></BODY></HTML> Wed, 02 Oct 2013 08:32:25 GMT 2013-10-02T08:32:25Z datetime field is displaying decimal data while loading qvd https://community.qlik.com/t5/QlikView/datetime-field-is-displaying-decimal-data-while-loading-qvd/m-p/501183#M187275 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have date fieldname having datetime datatype but when I load qvd data is dilsplaing with decimals not in date format.</P><P>how i load this data.<A href="https://community.qlik.com/qlik-users/1">Administrator</A></P></BODY></HTML> Wed, 02 Oct 2013 08:32:25 GMT https://community.qlik.com/t5/QlikView/datetime-field-is-displaying-decimal-data-while-loading-qvd/m-p/501183#M187275 2013-10-02T08:32:25Z Re: datetime field is displaying decimal data while loading qvd https://community.qlik.com/t5/QlikView/datetime-field-is-displaying-decimal-data-while-loading-qvd/m-p/501184#M187276 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Have you loaded the data as below;</P><P></P><P><SPAN class="Bold"><SPAN style="background-color: #3399ff; color: #ffffff;">t</SPAN><SPAN style="font-style: normal; font-weight: bold;"><SPAN style="background-color: #3399ff; color: #ffffff;">imestamp</SPAN>( </SPAN></SPAN><SPAN style="font-style: normal; font-weight: bold;">A</SPAN><SPAN style="font-style: normal; font-weight: bold;">,</SPAN><SPAN style="font-style: normal; font-weight: bold;">'YYYY-MM-DD hh.mm'</SPAN><SPAN class="Bold">)</SPAN></P><P><SPAN class="Bold"><BR /></SPAN></P><P><SPAN class="Bold">Where A is your data field.</SPAN></P><P><SPAN class="Bold"><BR /></SPAN></P><P><SPAN class="Bold"><BR /></SPAN></P><P><SPAN class="Bold">Regards</SPAN></P><P><SPAN class="Bold"><BR /></SPAN></P><P><SPAN class="Bold">Steve<BR /></SPAN></P></BODY></HTML> Wed, 02 Oct 2013 08:35:34 GMT https://community.qlik.com/t5/QlikView/datetime-field-is-displaying-decimal-data-while-loading-qvd/m-p/501184#M187276 2013-10-02T08:35:34Z Re: datetime field is displaying decimal data while loading qvd https://community.qlik.com/t5/QlikView/datetime-field-is-displaying-decimal-data-while-loading-qvd/m-p/501185#M187277 <HTML><HEAD></HEAD><BODY><P>Hi Pankaj.</P><P></P><P>use Date#() and Date() function in in load script to format the date accordingly.</P><P></P><P>read in help file about these functions.</P></BODY></HTML> Wed, 02 Oct 2013 09:00:32 GMT https://community.qlik.com/t5/QlikView/datetime-field-is-displaying-decimal-data-while-loading-qvd/m-p/501185#M187277 israrkhan 2013-10-02T09:00:32Z