Sort Date by MM./DD but ignore year

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

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

Douglas J. Steele

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