Unanswered: Birthdate - need to separate mm dd yyyy
I have a DOB field and would like to separate the mm dd yyyy in a query (I don't need to store this info separately in a table because I am already storing the DOB itself). Why? I need to run reports for all birthdays in January, or all birthdays in 1989. Hope that makes sense.