Skip to main content
Solved

Chronological Date Order for Grouping from Concatenate Field

  • August 7, 2024
  • 2 replies
  • 27 views

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?

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

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
  • Author
  • Known Participant
  • August 9, 2024

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