You want to use a BETWEEN query using something like Time#beginning_of_week and Time#next_week documented at http:// api.rubyonrails.com/classes/ActiveSupport/CoreExtensions/Time/ Calculations.html#M000338.
-Bill Siggelkow
Keep up to date with Rails on Twitter and This Week in Rails
Policies: Conduct, License, Maintenance, Security, Trademarks