Birthdate Query

  • Thread starter Thread starter Torie
  • Start date Start date
T

Torie

Hi,

I have a birthdate field that is filled with birthdates in
the following format: "1950-03-29". I want to know if it
is possible to do a query that returns the results of all
birthdates in a certain month and day regardless of the
year. Is it possible to do this? However, I still want the
query to return the year as well. Any advice and/or
comments would be greatly appreciated.

Thanks
 
Torie

Is your field defined as a datetime datatype, or text? Format and datatype
are not equivalent.

If text, take a look at the Left(), Right() and Mid() functions -- use them
in a query to "extract" the portions you want.

If datetime, look at the Day(), Month(), Year() functions -- also use them
in a query.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top