I need to convert a FileMaker timestamp into a different timestamp format as follows;
- it needs to be the time as seconds since midnight, January 1, 1970 UTC
- I'm able to generate the UTC offset in minutes, e.g. 660 or -240
The timestamp I'm referencing will be the value returned from the Get ( CurrentTimeStamp ) function. Not sure if I can incorporate the Get ( CurrentTimeUTCMilliseconds ) function here as well?
The result will look like '1331161200' which is equivalent to 03/07/2012 @ 11:00pm (UTC).