Hi, I am trying to return all the records in my table for which a date comparison reveals that that date is within 7 days. The code I have written looks like this:
@subscriptions = find(:all, :conditions => ['subscriptions.user_id = ? AND subscriptions.confirmed = 1 AND (DATEDIFF(day,now(),events.start_on) < 7)',user_id], :joins => "INNER JOIN events on subscriptions.event_id = events.id")
@subscriptions = find(:all, :conditions => ['subscriptions.user_id = ? AND subscriptions.confirmed = 1 AND events.start_on >= ?', user_id, 7.days.ago.at_beginning_of_day], :joins => "INNER JOIN events on subscriptions.event_id = events.id")
-philip
