Jul 10, 2019 08:45 PM
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.
Jul 10, 2019 08:49 PM
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})
Jul 13, 2019 04:35 AM
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.