Compare Birthdays with todays deade

[gal4y]

I would like to compare an inputted Birthday (ShortDate) with today's date. Display in a query the birthdays within 7 days of today's date (before and after Date()).

Thank you for any assistance.

Greg

 

[tlbroadbent]

Here is one query that will do what you need. It returns today's birthdays plus 7 days before and after.

SELECT m.MemmberName, m.BirthDt, m.Tele FROM Members m
WHERE DateAdd("yyyy",DateDiff("yyyy",[m].[Birthdt],Date()),[m].[BirthDt])) Between Date()-7 And Date()+7)); If you want to get the best answer for your question read faq183-874.

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm