AnsweredAssumed Answered

How to find a field based on a calculation on another field.

Question asked by aiharris on Aug 13, 2018
Latest reply on Aug 16, 2018 by philmodjunk

In several of my DBs, I have the same issue. One field is a date, the other is a variable such as range of motion of a knee, patient weight, or it could be stock prices. It is easy to define a global variable that is the maximum or minimum of the variable that is not the date.


How could I create another calculated value that represents the date of the Lowest Stock price, Highest stock price etc. In the case of the range of motion of a knee, I'd also need to be able to sort for the first date with the maximum ROM.


Seems that this should be easy, but so far, I'm striking out.


Thanks in advance.