Sort Date by MM./DD but ignore year

  • Thread starter Thread starter TDP
  • Start date Start date
T

TDP

I have a table that includes birthdays. I want to sort
based on birthday, regardless of the year of birth. How
can this be done? Everthing I try includes year in the
sort.
 
You can create a new field in your query - a concatenation
using the datepart function. You can concatenate your
birthday's month and day in this field. Then you can sort
on it.
 
Back
Top