Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Sorting a date field by month and day

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

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.