How to specify a less than today condition on a date in Rails ActiveRecord

Question

I'm trying to figure out how to pull all the records in my set where their fields publish is true and expires is less than today. I have the following but I don't think the less than part is working, can someone please point me on the right track?

Announcement.where(publish: true, :expires < Date.today)

Thanks in advance for your help

question from:https://stackoverflow.com/questions/8457902/how-to-specify-a-less-than-today-condition-on-a-date-in-rails-activerecord

Answer 1

Try this:

Announcement.where("publish = ? AND expires < ?", true, Date.today)