topic Re: Convert Datetime Stamp to Decimal (1,2,3 places) in QlikView https://community.qlik.com/t5/QlikView/Convert-Datetime-Stamp-to-Decimal-1-2-3-places/m-p/1243662#M872878 <HTML><HEAD></HEAD><BODY><P>Hi Sai,</P><P></P><P>I can´t uderstand you so well.</P><P></P><P>num(DATE_FIELD, '###,000') ???</P><P></P><P>Regards </P><P></P><P>Miguel del Valle</P></BODY></HTML> Mon, 14 Nov 2016 10:35:08 GMT migueldelval 2016-11-14T10:35:08Z Convert Datetime Stamp to Decimal (1,2,3 places) https://community.qlik.com/t5/QlikView/Convert-Datetime-Stamp-to-Decimal-1-2-3-places/m-p/1243659#M872875 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; All,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; How to convert Datetime Stamp to Decimal values(1,2,3 places).</P><P></P><P>Thanks &amp; regards,</P><P>Madhu</P><P></P><P><A href="https://community.qlik.com/qlik-users/202070" target="_blank">reddys310</A>‌</P><P><A href="https://community.qlik.com/qlik-users/2006" target="_blank">jimhalpert</A>‌</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Convert-Datetime-Stamp-to-Decimal-1-2-3-places/m-p/1243659#M872875 2020-11-25T16:16:04Z Re: Convert Datetime Stamp to Decimal (1,2,3 places) https://community.qlik.com/t5/QlikView/Convert-Datetime-Stamp-to-Decimal-1-2-3-places/m-p/1243660#M872876 <HTML><HEAD></HEAD><BODY><P>can you eloberate your issue?</P></BODY></HTML> Mon, 14 Nov 2016 10:31:44 GMT https://community.qlik.com/t5/QlikView/Convert-Datetime-Stamp-to-Decimal-1-2-3-places/m-p/1243660#M872876 Chanty4u 2016-11-14T10:31:44Z Re: Convert Datetime Stamp to Decimal (1,2,3 places) https://community.qlik.com/t5/QlikView/Convert-Datetime-Stamp-to-Decimal-1-2-3-places/m-p/1243661#M872877 <HTML><HEAD></HEAD><BODY><P>like ethis?</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">date#(subfield(MyDateString,' ',1),'dd.MM.yyyy') as MyDate</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">date#(subfield(MyDateString,' ',2),'hh:mm:ss') as MyTime</P></BODY></HTML> Mon, 14 Nov 2016 10:34:12 GMT https://community.qlik.com/t5/QlikView/Convert-Datetime-Stamp-to-Decimal-1-2-3-places/m-p/1243661#M872877 Chanty4u 2016-11-14T10:34:12Z Re: Convert Datetime Stamp to Decimal (1,2,3 places) https://community.qlik.com/t5/QlikView/Convert-Datetime-Stamp-to-Decimal-1-2-3-places/m-p/1243662#M872878 <HTML><HEAD></HEAD><BODY><P>Hi Sai,</P><P></P><P>I can´t uderstand you so well.</P><P></P><P>num(DATE_FIELD, '###,000') ???</P><P></P><P>Regards </P><P></P><P>Miguel del Valle</P></BODY></HTML> Mon, 14 Nov 2016 10:35:08 GMT https://community.qlik.com/t5/QlikView/Convert-Datetime-Stamp-to-Decimal-1-2-3-places/m-p/1243662#M872878 migueldelval 2016-11-14T10:35:08Z Re: Convert Datetime Stamp to Decimal (1,2,3 places) https://community.qlik.com/t5/QlikView/Convert-Datetime-Stamp-to-Decimal-1-2-3-places/m-p/1243663#M872879 <HTML><HEAD></HEAD><BODY><P>Hope this helps</P><P></P><P><A href="https://community.qlik.com/docs/DOC-8224">Logic behind date conversion</A></P></BODY></HTML> Mon, 14 Nov 2016 10:57:00 GMT https://community.qlik.com/t5/QlikView/Convert-Datetime-Stamp-to-Decimal-1-2-3-places/m-p/1243663#M872879 Anil_Babu_Samineni 2016-11-14T10:57:00Z