How do I search for a date field after or before a certain date in Active Record

activerecord, ruby-on-rails, ruby-on-rails-3

Solution

You can simply to this :

User.where("created_at >= ?", start_date )

Or this

User.where("created_at <= ?", end_date )

Problem

I know I can use a range to search where a date lies between 2 dates. For example: ``` User.where(:created_at => start_date..end_date ) ``` But how would I do an open ended search for all dates before or after a date? Thanks for any help

Original source

Related problems