Sort table on Month of a date field

[keithvbk]

I am trying to create a report of bithdays sorted by month . I have a field called Birthday1 . Data is in format mm/dd/yyyy .

While on the "date" subject, How do you Find records who's month is 9. I do not know how to specify the month in Find mode.

I appreciate your help !
Keith

 

[jaco8867]

Create a new calculation field in the database using either:

Month(date field) returns 1-12
or
MonthName(date field) returns Month name as text

Hope that Helps
John