Sort by Month/Year

A

awente

I am new to the database world and am trying to organize employee records. Is there a way to Query or Filter the database to return all of the birthdays that will fall within a given month.
 
A

Allen Browne

Type a calculated field into the query that returns the person's birthday
this year:

Birthday: DateSerial(Year(Date()), Month([DOB]), Day([DOB]))

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.
awente said:
I am new to the database world and am trying to organize employee records.
Click to expand...
Is there a way to Query or Filter the database to return all of the
birthdays that will fall within a given month.
 
Top