1 Reply Latest reply: Jul 14, 2016 5:09 AM by Gysbert Wassenaar RSS

    Integer8 to TimeStamp conversion

    Vijay Kumar

      I am trying to convert the Integer8 value to timestamp using the below thread.

       

      https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwiR6_bI4fDNAhUo4oMKHUhxBDkQFggc…

       

      But not getting the right value. Really have no idea what is going wrong. Can someone help me please..

       

      My Integer8 field name is accountExpires

       

      Below is the script I am using.. timestamp(left(accountExpires,11)/86400-109205)

       

      Result I am getting is ..

       

        

      accountExpiresNew Time Stamp
      922337203685477580710/9/4523 9:52:48 PM