Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Grouping and sorting issue - by date

Topic Labels: Dates & Timezones
571 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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:

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

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