Subtracting Dates

[waqasaslammmeo]

Hello Every One !

I m working on a software , i have one field name expiry_Date , now i want to make an query which subtract the current date from the expiry_date and give answer in no.of days , i use getdate() for current date ,

can any one help me:(

Regards

M.Waqas Aslam

[pritaeas]

Have a look at DATEDIFF() .

[waqasaslammmeo]

Have a look at DATEDIFF() .

thanks , it works for me , :) thank you so much

Regards

M.Waqas