Criteria for only certain months of a birthdate

G

Guest

How do I retrieve only birthdates in the months of May, Jun, July in a query?
I have a DOB field that is date formatted and need to pull up only
birthdates in those 3 months. What do I set the criteria to? Thanks ahead
of time for any help.
 
G

Guest

Use the month i a query.

Select * From TableName Where Month(FieldName) In (5,6,7)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top