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
Sep 21, 2021 10:15 PM
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
Sep 22, 2021 05:40 AM
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.
Sep 22, 2021 06:09 AM
Thank you so much! This will work fine for my purposes!