3 Dates in Dataset - Need the Middle

[wonkymeister]

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?

[Kushal_Chawda]

@wonkymeister  try below

MIN(MyDateField,2)

or

firstsortedvalue(MyDateField, MyDateField,2)

[wonkymeister]

Cheers, but the the first just pulls through the last date and the 2nd doesnt work?

[Vegar · Accepted solution]

MIN(MyDateField,2) should work, but if it is not then median(MyDateField) could work in your case.

[Kushal_Chawda]

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.

[wonkymeister]

Thanks for help guys!!!!!!