Advertisement

06.29.2008 at 11:34AM PDT, ID: 23525227
[x]
Attachment Details

SQL required to find birthdays within certain days

Asked by raj_nbr in MS SQL Server, Microsoft Access Database, Windows XP Operating System

Tags: MICROSOFT, SQL SERVER, 5, SQL

I need an SQL to fetch records of people whose birthdays are  approaching in the next x days. I do not want to use multiple conditions for month and year (I can sql it by checking 3 conditions - current month=birthmonth, currentmonth+1=birthmonth, currentmonth=12 and birthmonth=1). I need to use a simple statement like current_yeared_birthdate - currentdate  between 0 and 7

The database is sqlserver/mysql/access

How do I do it?Start Free Trial
 
Keywords: SQL required to find birthdays within c…
Title
1 birthday script
2 Birthdays
3 Showing Birthdays
4 Get Birthday
5 Find Birthdays in next 7 days
6 Query for birthdays
 
Loading Advertisement...
 
[+][-]06.29.2008 at 12:44PM PDT, ID: 21895243

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.29.2008 at 01:43PM PDT, ID: 21895403

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.29.2008 at 02:55PM PDT, ID: 21895639

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.29.2008 at 05:42PM PDT, ID: 21896067

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.30.2008 at 12:23AM PDT, ID: 21897264

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.30.2008 at 06:31AM PDT, ID: 21898943

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.30.2008 at 06:55AM PDT, ID: 21899144

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.30.2008 at 09:45AM PDT, ID: 21900778

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.30.2008 at 10:04AM PDT, ID: 21900965

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.25.2008 at 02:59AM PDT, ID: 22087146

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.25.2008 at 04:09AM PDT, ID: 22087406

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, Microsoft Access Database, Windows XP Operating System
Tags: MICROSOFT, SQL SERVER, 5, SQL
Sign Up Now!
Solution Provided By: cactus_data
Participating Experts: 4
Solution Grade: A
 
 
[+][-]07.25.2008 at 09:27AM PDT, ID: 22090033

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628