Skip to main content
Question

Different Ideas for Sorting and Grouping By Month Name

  • February 24, 2021
  • 0 replies
  • 85 views

Forum|alt.badge.img+14
What different techniques do people use for sorting and grouping by month, but also having them in the correct order?

For example, I have a formula field that changes the month/year to January 2021, February 2021 etc. I would love to group and sort by that, but I can't or it will be in alphabetical order, not actual month sequence.

I typically end up using a field that is something like: 1.2021, 2.2021, etc.

I was wondering if other people have come up with any tricks. I did consider using rich text and putting 1,2,3,4 in the front using a white color text so it is essentially invisible.

Other ideas?

------------------------------
Mike Tamoush
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
I either create a field on the format YYYY-MM-DD or I create a field which is an actual formula date field type and I make it be the first of the month.  Then I group by that date field, by month.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------