I have a set of records with a birthdate field in each.

I would like to sort on the birthdate so as to look for birthdays in a given week. The birthdate sorts by year as well as date so that I have to look through all the years. If I do a calculation to strip off the year, then the new fields with only month and day don't sort correctly.

(1/10 comes before 1/2 and 10/1 comes before 2/1)

Any ideas.

Just create two fields, instead of just one:

Day (calculation, number) = Day(Date)

Month (calculation, number) = Month(Date)

Sort by:

Month <-- first

Day <-- next

-bd