figuring out a week's time

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
http://www.jadecove.com