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.




      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