| Author: PHANI PRATHAP NADIGADDA 22 Aug 2007 | Member Level: Gold | Rating:  Points: 2 |
I expect you are using SQL Server as a database and you can achieve this by creating Store Procedure and passing start date and End Date as parameters. Like....
Create Proc GetSearchData
(
@StartDate DateTime,
@EndDate DateTime
)
AS
BEGIN
SELECT col1, col2, col3 FROM table_Name WHERE dateColumn BETWEEN @StartDate AND @EndDate;
END
GO
It will help you.
ALL THE BEST.
|