How to search date between two date?

select * from report_mstr where convert(varchar(10),modified_date,120)
between '2012-07-04' and '2012-07-11'
order by modified_date desc;