Converting MYSQL Timestamp to readable date in filemaker via ess dsn link
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:-
Can anyone help?
i think i need to use a let calculation but im not sure what I need to do from there.