Getting max date from min date
DipNov 28 2007 — edited Nov 28 2007Hello.
We have a problem with getting max values out of min values.
Example (table):
date.....................type
27.11.07 06:00........1
27.11.07 10:00........2
27.11.07 10:00........1
27.11.07 10:30........2
27.11.07 10:45........1
27.11.07 15:00........2
Max value is max time with type 1. In this case, max is at time 10:45.
Min value is max time with type 2, which must be smaller than max time with type 1.
So we have 10:45, which is good. And we need 10:30.
But we get two values for min. That is 10:00 and 10:30.
How can we solve that?
Thanks.