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

Sorting by chronological order

Topic Labels: Formulas
320 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Reply 1

Hi @Tiffany_Oney ,

You can use MM instead of MMMM to get the month number (even if another field) then use it to sort?