AnsweredAssumed Answered

Convert FileMaker Timestamp Question

Question asked by fmdataweb on Nov 23, 2017
Latest reply on Nov 24, 2017 by user19752

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).

 

Thanks

Outcomes