-- this sample query to display today and 5 days before from today select getdate(),DATEADD(dd,-5,getdate()) -- This sample query will return result between 5 days SELECT * FROM YourTable_Name WHERE YOURDateColumn BETWEEN DATEADD(dd,-5,getdate()) and getdate()
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)