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

Outcomes