AnsweredAssumed Answered

Timestamp Calculations

Question asked by johnyx2 on May 29, 2017
Latest reply on Aug 28, 2017 by fmpdude

Hello,

 

Please see these calculations and their results:

 

GetAsTimestamp ( "5/29/2017 5:30:13 PM" ) - 63631675814 = -1

GetAsTimestamp ( "5/29/2017 5:30:13 PM" ) - 63631675813 = 0

GetAsTimestamp ( "5/29/2017 5:30:13 PM" ) - 63631675812 = "1/1/0001 12:00:01 AM"

 

If the result is not positive, this returns the difference in seconds, otherwise it returns the Timestamp of that difference

Is this a bug?

 

 

By the way, anybody using FileMaker Custom Function:UTCOffset will not get the desired result if they are located East of UTC.

Change the custom function formula to:

GetAsNumber ( Get ( CurrentTimestamp ) ) - Floor ( Get ( CurrentTimeUTCMilliseconds ) / 1000 )

 

Thanks

Outcomes