Find the max date within a selected period

[C_Howarth]

I am trying to create a expression to find the last date within any selected period within the current year. Currently I have:

=max(Date(Year(Today())&GetFieldSelections([month])))

But this is returning a value with the year 2452 which is obviously not correct

[C_Howarth · Accepted solution]

Solved now thanks to a colleague:

=max({<[month code] = {$(=(Year(Today())&GetFieldSelections([month])))}>}[date])