Chronological Date Order for Grouping from Concatenate Field

[Kiersten_Kollin]

We leverage a concatenate field to be able to indicate when milestones fall during certain weeks. We are wondering if there is a way to revise the formula so that we can have the grouping be in order chronologically by year. I have supplied the formula that we have and how the grouping is appearing today below.

[TheTimeSavingCo · Accepted solution]

I think you're going to need to make the formula lead with the date and the year specifically I'm afraid

As a workaround, perhaps you could just filter out laste year's data?  Or maybe group by the year first?

[Kiersten_Kollin]

Thank you! Switching the year to the front made all the difference.