1 Reply Latest reply on Jan 13, 2010 6:39 AM by TSGal

    Filemkaer ESS calculation to convert Unix time to readable date

    jonnyt

      Title

      Filemkaer ESS calculation to convert Unix time to readable date

      Your post

      Hi there,

       

      I have a table in a website that has a creationg date that uses the PHP Time() function to insert the current timestamp.

       

      I think its also known as a UNIX timestamp. Which is what what you get when you call time() in PHP.
      It's the amount of seconds since 01-01-1970 00:00:00.

       

      How can I convert this into a readable timestamp inside filemaker using a calculation?

        • 1. Re: Filemkaer ESS calculation to convert Unix time to readable date
          TSGal

          jonnyt:

           

          Thank you for your post.

           

          If the result is the amount of seconds since 1/1/1970, then import that data into a Number field.  Then, the create a Timestamp calculation with the formula:

           

          62135596800 + <Number field>

           

          Since FileMaker Pro uses the number of seconds from 1/1/0001, the value 62135596800 is the number of seconds from 1/1/0001 to 1/1/1970.

           

          TSGal

          FileMaker, Inc.