# Finding record between 2 dates

**URL:** <https://discuss.rubyonrails.org/t/finding-record-between-2-dates/41360>\
**Category:** rubyonrails-talk\
**Created:** [April 8, 2009, 2:56pm UTC](https://discuss.rubyonrails.org/t/finding-record-between-2-dates/41360 "2009-04-08T14:56:49Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jaryl\_Sim](https://avatars.discourse-cdn.com/v4/letter/j/6de8d8/32.png) [@Jaryl\_Sim](https://discuss.rubyonrails.org/u/Jaryl_Sim)\
**Post date:** [April 8, 2009, 2:56pm UTC](https://discuss.rubyonrails.org/t/finding-record-between-2-dates/41360/1 "2009-04-08T14:56:49Z")

</div>

You can do this very easily with a named scope in your model:

named\_scope :between, lambda {|start\_date, end\_date| {:conditions =\> ["created\_at BETWEEN :start AND :end", {:start =\> start\_date, :end =\> end\_date}]}}