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:(


M.Waqas Aslam

Recommended Answers

All 2 Replies

Have a look at DATEDIFF().

Have a look at DATEDIFF().

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



Be a part of the DaniWeb community

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