How to pull birthdays for a given date range 1

[misha8765]

Thank you in advance for your help.

In a query, I want to pull all employees who have a birthday in May. Our date field is 99/99/00

I don't care about the year and I don't know the birth year in advance. I just want to know all birthday's for each month.

Any idea how I can write the code in the criteria of the date field?

Thank you

 

[belovedcej]

Change the birthday field to
MonthDate: Format$([FieldName], "mmmm").

then in the criteria field put [please enter month].

this would require the month be spelled out.

use "mmm" to get the three letter abbreviation, use "mm" to have a 2 digit numeric representation (e.g., 05), and use "m" to have a numeric representation of the minimum digits (e.g., "5")

 

[Golom]

A WHERE clause of the form

WHERE Month(DateOfBirth) = 5

will give you everyone with a May birthday.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]