Sort Month name field chronologically instead of alphabetically

Hello Airtable community

I have a formula field which show date as month name only: DATETIME_FORMAT({DELIVERY DATE}, “MMMM”) I wanted to use this field to group each month’s records.
Unfortunately, the sort function does not sort chronologically as it should for a date, but rather alphabetically. How can I force a chronological sort?

Thanks in advance
Sally

Hi Sally. The only way I know how would be like this…

DATETIME_FORMAT({DELIVERY DATE},'MM') & '-' & DATETIME_FORMAT({DELIVERY DATE},'MMMM')

It appends the 2 digit month to the front in order to sort the way you want.

2 Likes

Thank you so much! This will work fine for my purposes!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.