Hello,
    I am developing a simple calender in ASP which will display the next upcoming birthday of my member. Just like some forum have.

     I have a table which has 2 column

     cname | dob
     -------------------
     Joe | 9/12/1982
     Mathew | 2/17/1997
     Pat | 8/23/1880

     -------------------
     What SQL Query should I use to get the name of that person?

[u]Some basic information:
</u>
Database = Access (may be I can upgrade it into SQL Server 2000)

Date Format in database = mm/dd/yyyy

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

__________________
-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

Your question is to broad, what is your definition of "next upcoming birthday"? Is that 1 day, 2 days, or??

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

any date the is the nearest to the current date

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

....define NEAR? is that all birthdays for the current month, birthdays within 2 weeks of todays date?

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Within the current month


Thanx

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

and if it does not find any b'day within the current month then it will look in teh next month, and so on...

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

In MSSQL I would use the DATEADD([month, year, or day], n, getDate()) however, what you are asking is slightly a bit more complex;

For just the current month you coudl do something like

SELECT [data] FROM [table] WHERE dob BETWEEN getdate() AND DateAdd(month, 1, getDate())

but now, if the Row Count == 0 you want to do

SELECT [data] FROM [table] WHERE dob BETWEEN getdate() AND DateAdd(month, 2, getDate())

and so on.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

The DATEADD function does not work in MS Access, does it?

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

It does, but I am not sure if you can use it in a straight query like above but check out these links.

http://www.techonthenet.com/access/f...te/dateadd.php
http://experts.about.com/q/Using-MS-...40/DateAdd.htm
http://www.tek-tips.com/faqs.cfm?fid=4230

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature