TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Rashid Khan
NA
159
0
upcoming birthdays query
Apr 27 2010 3:20 AM
Hello Everyone.
i have query for upcoming birthday,
i want when user log in then on welcome page user can see upcoming birthday of next 10 days from the current date of their contact. i wrote this
select FirstName,DOB from PersonalAddBook where month(DOB)=month(getdate())
AND day(DOB)>=day(getdate()) order by DOB asc;
but the problem is this its only return same month's birthday result. like today is 27th April. and if my frnd's b'day is on 1st May then its not showing, i want,. query which always count 10 days from the current date and show. if any b'day is coming in tht 10 days period.
please update my query nd tell me how can i get the desired result.
Thanks
Reply
Answers (
2
)
Export Access table to Excel
Birthday Email Notifier