Filemkaer ESS calculation to convert Unix time to readable date
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?
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.