Max month (jan,feb,mar...)

[#1]

Hello, I need a variable with the max month:

=max(Monthdate)

But my Monthdate is: jan,feb,mar.... and with max(Monthdate) my result is 12.

Help please. Thank you!

[sunny_talwar · Accepted solution]

Try this:

Pick(Max(Monthdate), 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec')

[swuehl]

That's expected, Max() will most probably return a number.

But you can try like

=FirstSortedValue(DISTINCT  Monthdate, -Monthdate)

[#4]

That works! Thank you!

[#5]

Great solution. Thak you!