i have a data base with StockBalance, EconomicOrQuality, Price, Unit, lasDateOfIss.
n i need to retrieve stock balance,price,unit,and data of last issue
in to a grid wive .
the condition is that the retrieving data records must be old more than 90 days from the system date.
i can retrieve the details but dont know how to have a condition like that.so plz help mee
chathuD
-7
Junior Poster
Recommended Answers
Jump to PostHow do you determine the date of the item? The lasDateOf column? I have answered a similar thread about finding records regarding a payment date:
http://www.daniweb.com/forums/thread222265.htmlHere is an example of selecting all invoices older than 90 days:
Select * From Invoice Where OrderDate <= Cast(Floor(Cast(GetDate()-90 …
All 3 Replies
Reply to this topic
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.