Sql Query Help - ASP

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?

Some basic information:

Database = Access (may be I can upgrade it into SQL Server 2000)

Date Format in database = mm/dd/yyyy

 

you need to use the Query SELECT ***** WHERE ******

 

SELECT * from table WHERE dob > CURDATE() ORDER BY dob ASC LIMIT 1;

that's an example, from there you can sort/modify it to your needs. Not sure if CURDATE() works in access as Im working with mysql.

 

maybe its better to have
dob = '"&formatdatetime(DATE())&"'

 

anyway he can use it
I know what type of function it is and I use it which WORKS just fine, he can change the date time value automatically to the one he has in his DB which will make his work easier

 

that's what I was thinking as well, query not formatting.