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

Question

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

Possible duplicate of [Can you do greater than comparison on a date in a Rails 3 search?](https://stackoverflow.com/questions/4224600/can-you-do-greater-than-comparison-on-a-date-in-a-rails-3-search) — Brad Werth, Mar 29 '18 at 04:25

score 9 · Accepted Answer · answered Jul 25 '12 at 14:55

9

You can simply to this :

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

Or this

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

answered Jul 25 '12 at 14:55

Dougui

1 Answers1