search between dates

General Web Coding Microsoft Development
1

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.

2

SELECT * FROM [table] WHERE [date field] BETWEEN [start date] AND [end date]