activerecord - How to specify a less than today condition on a date in rails active record

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 dont think the less than part is working, can someone please point me on the right track?

  @announcements = 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-active-record

Answer 1

Try this:

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