Grouping and sorting issue - by date

[rbrauns]

Hi -
I’m running into a problem when I try to group a list of events. The dates are from Dec. 21 up to Dec. 22 and I’ve one column witha formula that extracts the month from the date column.
I can sort my table by the date field and it’s all fine, but when I then group by month, the order gets messed up. How can I create a grid view that is sorted by month and shows the month in the right order? And in addition with a two times December (21,22) entry??

Thanks for any help!

[Kamille_Parks]

Assuming your formula results in “December” and not “12”, you could adjust your formula to do something like:

DATETIME_FORMAT({Date A}, "YYYY - MM - MMMM")

to result in “2021 - 12 - December” so you can group by each month in the proper order.