Search by start date and end date

[mayanair]

hi,I have a list of information that is stored according to dates. Now im preparing an interface that lets the user choose a start date and an end date and when these dates are selected, the data that falls between these dates will be displayed... how do i do ths...thanx

[MAK]

SELECT * from
Table3 where date between # 2003-01-05 # and # 2003-03-06 # ;