Skip to main content

Sorting a date field by month and day

  • May 3, 2021
  • 1 reply
  • 23 views

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

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • May 3, 2021

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.