Date Querry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My db has a birthday field in short date format (mm/dd/yyyy).

How do I querry for all birthdays in say Jan, regardless of day or year?
 
Assuming a date field, "...WHERE Month(BirthDay) = 1"

If it's a text field, "...WHERE Month(CDate(BirthDay)) = 1"

HTH
 
Jb:
Type typing this in for the criteria......1=Month([Birthday])

This should give you all birthdays in Jan regardless of the day or year. Of
course this assumes the field name is "Birthday".

Hope this helps,
FatMan
 
In your query put something like the following at the top of a column:

BirthMonth:Month([birthday field])

In the criteria you would put the number 1 for Jan, 2 for Feb, etc.

This will only work IF your birthday field is an actual date/time field.
Something that looks like a date in a text field will take more work.
 
Back
Top