Sort Birth Dates in List View Starting from Current Month
In list view, I need to sort records for a class of students so they:
- Are grouped together by their respective birth months and sorted ascending by birth day.
- Remain together as a group even if their birthday for the current year has passed.
- Dynamically start the top of the sorted list with the current month, not necessarily January.
I've already parsed out student birth dates into birthMonthNumber = month ( DOB ), and birthDayNumber = day ( DOB ) and have placed these in the Sort Dialog, both in ascending order. The sort works fine except (of course) it starts the resulting sorted list beginning with January and that's not quite what I need.
Example: As I write this post the current month is November and I want the sorted list to display students with a November birth month to be at the head of the list and then shift the same November grouping to the bottom of the list on the first day of the next month (December, in this case). Students with December birthdays would then take their place at the top of the list, and so on.
The birth year is not relevant to the desired outcome, as far as I can tell.
Thanks for any advice.