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,