As Reiss says, you can use BETWEEN, or you can simply say
SELECT * FROM myTable WHERE [date] >= '2011-07-21' AND [date] <= '2011-07-28'
The later form is more flexible, in that it allows exclusive dates and well as inclusive - BETWEEN always includes both the start and end dates in the calculation.