I'd like to sort a Date of Birth field by the 'month' in order to sort
birthdays into their months. TIA.

In article <1171490291.756077.103250 (AT) l53g2000cwa (DOT) googlegroups.com>,
"yarravillebrad" <yarravillebrad (AT) yahoo (DOT) com.au> wrote:

Create a new Calculation field that extracts the month
eg.
BirthMonth Calculation, Number Result, Unstored
= Month(DateofBirth)

and then sort by this new field instead. This function gives you the
number of the month (eg. 1 for January, 7 for July, etc.) which makes
it perfect for sorting in calendar order (rather than the MonthName
function which will sort in alphabetical order).



Depending on what you're trying to do, you may also want the day.
ie.
BirthDay Calculation, Number Result, Unstored
= Day(DateofBirth)

and then sort in this order:

BirthMonth Increasing
BirthDay Increasing

to get the records in the correct calendar order.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)