sql query for date between

Hi,
This is velsamy, i have created the aspx page for retrieve the data by using date's selection , i used the query like this

SELECT * FROM report WHERE ( from_date BETWEEN '07/10/2012' AND '07/10/2012') OR ( from_date BETWEEN '07/10/2012' AND '07/10/2012') AND ( from_date= '07/10/2012') OR (from_date= '07/10/2012')
is this query is correct or not? if it wrong kindly give me the correct  query. its urgent
Thanks in advance,
Velsamy
...