Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Sorting a date field by month and day

Topic Labels: Formulas
975 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Louise_Nighting
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi There,

Brand new to Airtable, so apologies for this potentially stupid question.

Am I able to sort a series of dates by month and date only (year isn’t important for the sort)? My current workaround is pulling the month and day into their own columns, then having a third column using this formula (MONTH&" "&DAY) and then sorting the results of that formula. I’d rather not have 3 columns to do a basic sort if I can help it.

Thank you!

1 Reply 1

Unfortunately, as far as I know, that’s the only solution right now.

I’d love to know if someone else has some other trick for this.