This seems to work... SELECT Employees.EmployeeID, Employees.Birthdate FROM Employees WHERE ((Month([Birthdate])=Month(Date()) And Day([Birthdate])<=(Day(Date())+15))) OR ((Month([Birthdate])=Month(Date()) And Day([Birthdate])>=(Day(Date())-15)));
--- In [email protected], Sergio Gurgel <sergio.gur...@...> wrote: > > Good afternoon, > > I'm needing to perform the following query. > I have the birthday registered in the field in the table DAT_NAS PEOPLE. > This consultation will bring the birthdays on the last 15 days before and 15 > days later. > For example: > > Today is 04/08/2010. > The consultation will bring me the birthdays of 21/07/2010 to 19/08/2010, ie > all the birthdays of between 21/07/2010 and 19/08/2010. > > > Can anyone help me since I am not able to create this query. > > Thank you. > > Sérgio Gurgel > > http://www.sergiogurgel.eti.br | twitter @sergiogurgel | skype sergio_gurgel > | gtalk sergio.gur...@... | msn ser...@... > > > [Non-text portions of this message have been removed] >
