returning Birthdays

[jonhc]

I have a database with customer birthdates and would like
to run a daily report that returns anyones birthdate that
i enter in. I don't know how to handle the year aspect.
If enter today's date I want anyone with the same month
and day to come up. Thank for help

 

[dibblm]

have you tried either now() or date()

 

[Allen Browne]

The person's birthday this year is:
DateSerial(Year(Date), Month([BirthDate], Day([BirthDate])