Skip to main content

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.


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.


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


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.


This has helped me massively - thank you!


Reply