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.
 

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

Similar Threads

Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
New computer, how do i move outlook 365 ENTIRELY? 0
Filter in A report 1
Eliminating Dates based on a measure 1
Working on birthday "book" for my wife and having layout/editing trouble 0
Record Review Process 2
conditional reporting 4
Access query 1

Top