Skip to main content

Sorting Date fields

  • July 11, 2019
  • 2 replies
  • 21 views

I Have date fields for wedding anniversaries and for birthdays. Is there an easy way to sort them into month order. We use this at church to acknowledge those having a birthday or wedding anniversary during the coming week.

This topic has been closed for replies.

2 replies

Justin_Barrett
Forum|alt.badge.img+21

Welcome to the community, Terr! :grinning_face_with_big_eyes: One option is to add a formula field that extracts the month as a numeric value, then sort by that field. The formula can simply be:

MONTH({Date Field})

  • Author
  • New Participant
  • July 13, 2019

Welcome to the community, Terr! :grinning_face_with_big_eyes: One option is to add a formula field that extracts the month as a numeric value, then sort by that field. The formula can simply be:

MONTH({Date Field})

Thanks Justin, that did the trick. I changed date format to friendly and hid formula field. Still getting to grips with Airtable. The little grey cells get a bit slower when you get into your 70s.