AnsweredAssumed Answered

Converting MYSQL Timestamp to readable date in filemaker via ess dsn link

Question asked by jonnyt on Oct 6, 2009
Latest reply on Oct 7, 2009 by comment_1

Title

Converting MYSQL Timestamp to readable date in filemaker via ess dsn link

Post

I have an orders table on my website that has a createdDate timestamp to identify when the sale was made.

 

The website is made using virtuemart and looking at the datatype for the cdate colum it says it is an integer datatype.

 

I need to convert this in filemaker using a calculation so that the timestamp displays in readable UK format DD/MM/YYYY hh:mm:ss

 

Some examples of the data in that column is:-

 

1253870376

1253875556

1254300314

 

 

Can anyone help?

 

i think i need to use a let calculation but im not sure what I need to do from there.

Outcomes