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.
Sorting Date fields
This topic has been closed for replies.
+21Welcome 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})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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.