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.