AnsweredAssumed Answered

Timestamp difference?

Question asked by disabled_morkus on Feb 21, 2016
Latest reply on Feb 22, 2016 by disabled_morkus

Trying to simply compute the difference between two timestamps using a calculation similar to the one below.


This should be simple calculation since in most environments a Timestamp is just a "Time" value you can then do a simple calculation on. FileMaker is probably just fine in what it's doing, but I don't recall this calculation being difficult in the past.


Yet, the approach below doesn't seem to work regardless of what I try.


( ExecuteSQL("select max(<TS_DATE>) from <TABLE>" ; ""; "") - ExecuteSQL("select min(<TS_DATE>) from <TABLE>" ; ""; "") )  / (tried different divisors)


I've seen some CFs that have recursive solutions (???), but it's hard to believe you would need that to subtract two TimeStamps, it should only take a formula, right?


I've tried dividing by 84600 and multiples of that, but the result is not even close.


Clearly missing something here....


Thanks in advance,


- m