# Simple query

**URL:** <https://www.ruby-forum.com/t/simple-query/120526>\
**Category:** Rails\
**Created:** [November 17, 2007, 11:30pm UTC](https://www.ruby-forum.com/t/simple-query/120526 "2007-11-17T23:30:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Piotr\_N](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/e9c0ed/32.png) [@Piotr\_N](https://www.ruby-forum.com/u/Piotr_N)\
**Post date:** [November 17, 2007, 11:30pm UTC](https://www.ruby-forum.com/t/simple-query/120526/1 "2007-11-17T23:30:40Z")

</div>

hi,\

how do i get all records form my model, which are not older than 3 days  
? Say i have column in my users table ‘sign\_in\_date’, i want retrieve  
all records with sign\_in\_date not older than 3 days from now.

thx

regards

---

<div class="post-metadata">

**Author:** ![Piotr\_N](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/e9c0ed/32.png) [@Piotr\_N](https://www.ruby-forum.com/u/Piotr_N)\
**Post date:** [November 18, 2007, 12:01am UTC](https://www.ruby-forum.com/t/simple-query/120526/2 "2007-11-18T00:01:04Z")

</div>

three\_days\_ago = (DateTime.now - 3.days)  
YourModel.find(:all, :conditions =\> [‘sign\_in\_date \> ?’,  
three\_days\_ago])

---

<div class="post-metadata">

**Author:** ![Piotr\_N](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/e9c0ed/32.png) [@Piotr\_N](https://www.ruby-forum.com/u/Piotr_N)\
**Post date:** [November 18, 2007, 12:18am UTC](https://www.ruby-forum.com/t/simple-query/120526/3 "2007-11-18T00:18:01Z")

</div>

Jean-Sébastien pisze:

> three\_days\_ago = (DateTime.now - 3.days)  
> YourModel.find(:all, :conditions =\> [‘sign\_in\_date \> ?’,  
> three\_days\_ago])

3.days lol 🙂  
great stuff man