Help

Sorting Date fields

1554 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Terr_Ol
4 - Data Explorer
4 - Data Explorer

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.

2 Replies 2

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.