search between dates

[bitwizer]

Hi,
i made an advanced search engine in my site that searches thru records in mssql database using asp codes.
But i failed in makin the search between user input dates (i.e from date to date).
So if there is any body can help me achieving how to search thru date/time acceping user input starting & end date.

 

[Mart]

SELECT * FROM

WHERE [date field] BETWEEN [start date] AND [end date]