Hi check this.... select mem_name from t1 where b_date between convert(varchar(10),getdate(),101) and convert(varchar(10),dateadd(d,6,getdate()),101)
If date_of_birth is date type field u can remove convert function Regards, Tarun -----Original Message----- From: yours_truly_jaan [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 16, 2005 11:08 AM To: [email protected] Subject: [AspNetAnyQuestionIsOk] URGENT SQL Query Friends, I'm facing a big problem. I'm having a table T1 which having fields mem_name and date_of_birth. I want a SQL query which should give me mem_name whose birthdays are today and in next 6 days i.e. when i will run this query today i.e. on 16-feb-2005 it should give me the names of all the persons whose birthday lies in between 16-feb and 22-feb. Its really urgent. Thnx in advance. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
