Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
i have 3 dates in my dataset - of which i want to use the oldest two as labels.
i.e.
01/02/2021
13/05/2020
09/10/2019
the oldest is easy ie MIN(MyDateField). But whats the easy/quick way to get the middle date i.e. 13/05/2020?
MIN(MyDateField,2) should work, but if it is not then median(MyDateField) could work in your case.
Cheers, but the the first just pulls through the last date and the 2nd doesnt work?
MIN(MyDateField,2) should work, but if it is not then median(MyDateField) could work in your case.
I think you said two statements. First, oldest two for which I already suggested solution. Second, middle date for which what Vegar suggested should work.
Thanks for help guys!!!!!!