topic Re: Integer8 to TimeStamp conversion in QlikView https://community.qlik.com/t5/QlikView/Integer8-to-TimeStamp-conversion/m-p/1150150#M633078 <HTML><HEAD></HEAD><BODY><P>Next time read the documentation <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P></P><P><A href="https://msdn.microsoft.com/en-us/library/ms675098(v=vs.85).aspx" title="https://msdn.microsoft.com/en-us/library/ms675098(v=vs.85).aspx">https://msdn.microsoft.com/en-us/library/ms675098(v=vs.85).aspx:</A></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>T<SPAN style="color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px;">he date when the account expires. This value represents the number of 100-nanosecond intervals since January 1, 1601 (UTC). <STRONG>A value of 0 or 0x7FFFFFFFFFFFFFFF (9223372036854775807) indicates that the account never expires.</STRONG></SPAN></P> </TD></TR></TBODY></TABLE></BLOCKQUOTE></BODY></HTML> Thu, 14 Jul 2016 09:09:51 GMT Gysbert_Wassenaar 2016-07-14T09:09:51Z Integer8 to TimeStamp conversion https://community.qlik.com/t5/QlikView/Integer8-to-TimeStamp-conversion/m-p/1150149#M633077 <HTML><HEAD></HEAD><BODY><P>I am trying to convert the Integer8 value to timestamp using the below thread.</P><P></P><P><A href="https://www.google.com/url?sa=t&amp;rct=j&amp;q=&amp;esrc=s&amp;source=web&amp;cd=1&amp;cad=rja&amp;uact=8&amp;ved=0ahUKEwiR6_bI4fDNAhUo4oMKHUhxBDkQFggcMAA&amp;url=https%3A%2F%2Fcommunity.qlik.com%2Fthread%2F110907&amp;usg=AFQjCNEmZQPWN6uw6xZyVlIVt26o6rabow&amp;sig2=CzWwhINIuW2IaBUyIWV0lw&amp;bvm=bv.126993452,d.amc" title="https://www.google.com/url?sa=t&amp;rct=j&amp;q=&amp;esrc=s&amp;source=web&amp;cd=1&amp;cad=rja&amp;uact=8&amp;ved=0ahUKEwiR6_bI4fDNAhUo4oMKHUhxBDkQFggcMAA&amp;url=https%3A%2F%2Fcommunity.qlik.com%2Fthread%2F110907&amp;usg=AFQjCNEmZQPWN6uw6xZyVlIVt26o6rabow&amp;sig2=CzWwhINIuW2IaBUyIWV0lw&amp;bvm=bv.126993452,d.amc">https://www.google.com/url?sa=t&amp;rct=j&amp;q=&amp;esrc=s&amp;source=web&amp;cd=1&amp;cad=rja&amp;uact=8&amp;ved=0ahUKEwiR6_bI4fDNAhUo4oMKHUhxBDkQFggc…</A></P><P></P><P>But not getting the right value. Really have no idea what is going wrong. Can someone help me please..</P><P></P><P>My Integer8 field name is <STRONG>accountExpires</STRONG></P><P></P><P>Below is the script I am using.. <STRONG>timestamp(left(accountExpires,11)/86400-109205)</STRONG></P><P></P><P>Result I am getting is ..</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="64" style="height: 64px; width: 360px;" width="360"><TBODY><TR><TD height="20" width="105">accountExpires</TD><TD class="xl65" width="154">New Time Stamp</TD></TR><TR><TD height="20">9223372036854775807</TD><TD align="right" class="xl65">10/9/4523 9:52:48 PM</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 13 Jul 2016 16:10:01 GMT https://community.qlik.com/t5/QlikView/Integer8-to-TimeStamp-conversion/m-p/1150149#M633077 Anonymous 2016-07-13T16:10:01Z Re: Integer8 to TimeStamp conversion https://community.qlik.com/t5/QlikView/Integer8-to-TimeStamp-conversion/m-p/1150150#M633078 <HTML><HEAD></HEAD><BODY><P>Next time read the documentation <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P></P><P><A href="https://msdn.microsoft.com/en-us/library/ms675098(v=vs.85).aspx" title="https://msdn.microsoft.com/en-us/library/ms675098(v=vs.85).aspx">https://msdn.microsoft.com/en-us/library/ms675098(v=vs.85).aspx:</A></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>T<SPAN style="color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px;">he date when the account expires. This value represents the number of 100-nanosecond intervals since January 1, 1601 (UTC). <STRONG>A value of 0 or 0x7FFFFFFFFFFFFFFF (9223372036854775807) indicates that the account never expires.</STRONG></SPAN></P> </TD></TR></TBODY></TABLE></BLOCKQUOTE></BODY></HTML> Thu, 14 Jul 2016 09:09:51 GMT https://community.qlik.com/t5/QlikView/Integer8-to-TimeStamp-conversion/m-p/1150150#M633078 Gysbert_Wassenaar 2016-07-14T09:09:51Z