AnsweredAssumed Answered

Sort Birth Dates in List View Starting from Current Month

Question asked by illumine on Nov 16, 2014
Latest reply on Nov 17, 2014 by illumine

Title

Sort Birth Dates in List View Starting from Current Month

Post

In list view, I need to sort records for a class of students so they:

         
  1. Are grouped together by their respective birth months and sorted ascending by birth day.
  2.      
  3. Remain together as a group even if their birthday for the current year has passed.
  4.      
  5. 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.

Outcomes