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

Have a look at DATEDIFF().

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

Regards

M.Waqas

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.