How can I do 6.months.ago - 1.days.ago in Ruby on Rails

Question

How can I achieve the following behavior in Ruby on Rails 4.1.4?

Purchase.where('purchase_date <= ?', 6.months.ago - 1.days.ago).each do |purchase|
    # ...
end

Thanks in advance.

Answer 1

Make a BETWEEN filter? If use ActiveRecord, do this:

Purchase.where(purchase_date: 6.months.ago..1.day.ago).each do |purchase|
  ## do .....
end

Answer 2

How about:

Purchase.where('purchase_date <= ?', 6.months.ago + 1.day).each do |purchase|