Convert Dates FMP/SQL

[Ocean West]

I am working on a way to interface FMP to FMForums with ESS, the dates of posts here are stored as GMT Unix such as "1204660734" = 03/04/08 11:58 AM (GMT -0800)

I need a way to convert a FileMaker TimeStamp into that format, vice versa.

[Ocean West]

never mind - found it = "Search is my friend" :blush2:

[Ocean West]

Ok spoke too soon...

Found that Date ( 1 ; 1 ; 1970 ) + unixdate / 86400 will result in the correct date.

however I am not finding a solution to extract the current time?

[comment]

Hi Stephen,

Search *IS* your friend:

http://www.fmforums.com/forum/showtopic.php?tid/181324/post/225722/#225722

[Ocean West]

Thanks michael :yourock: