Grouping and sorting issue - by date

Topic Labels: Dates & Timezones
699 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1

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


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