Skip to main content
Solved

Chronological Date Order for Grouping from Concatenate Field


Forum|alt.badge.img+19

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.

 

Best answer by TheTimeSavingCo

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?

View original
This topic has been closed for replies.

2 replies

TheTimeSavingCo
Forum|alt.badge.img+32

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?


Forum|alt.badge.img+19

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