Sort Date by MM./DD but ignore year

[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.

 

[Cheryl Fischer]

Have you tried?

ORDER BY Month([BirthDate]), Day([BirthDate])



hth,

 

[Les]

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.

 

[Douglas J. Steele]

Why bother concatenating? A simple Format$([Birthdate], "mmdd") will
suffice.