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
Mar 14, 2022 11:58 AM
I have a formula that groups together transactions within each month.
Formula is:
DATETIME_FORMAT({Pickup Date}, ‘MMMM’)
I need to sort the months in chronological order instead of alphabetical. Is there a concatenation or formula that will return this result?
Mar 15, 2022 03:44 AM
Hi @Tiffany_Oney ,
You can use MM instead of MMMM to get the month number (even if another field) then use it to sort?