Sorting Dates by Month and Day
How can I sort records by date using only the month and day, not the year?
Does this mean that records dated January 1st, 2012 and others dated January 1st, 2011 would sort into the same group?
Define two calculation fields:
cMonthNumber as: Month(YourDateField)
cDay as Day (YourDateField)
Be sure that number is selected as the return type for both calculation fields.
Then sort your records first by cMonthNumber, then by cDay
Retrieving data ...