How do I get max(Month) to appear as text when multiple months are selected?

[#1]

I am having an issue where my expression only calculates if I use the text form of the month {Jul}, but when I select multiple months I cannot get a function that gives me the max(Month) in the form of text, only the output 7.  Is there a way to get the max month to appear in text form?

I have tried a handful of functions and variables, but any help would be appreciated.

Thanks,

Craig

[Jason_Michaelides · Accepted solution]

=Date(Date#(Max(Month),'MM'),'MMM')

seems to do the trick.

Jason

[#3]

Thanks a lot, I really appreciate it!