# How to find records

**URL:** <https://www.ruby-forum.com/t/how-to-find-records/178899>\
**Category:** Rails\
**Created:** [November 13, 2009, 6:53am UTC](https://www.ruby-forum.com/t/how-to-find-records/178899 "2009-11-13T06:53:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![newb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/2acd7d/32.png) [@newb](https://www.ruby-forum.com/u/newb)\
**Post date:** [November 13, 2009, 6:53am UTC](https://www.ruby-forum.com/t/how-to-find-records/178899/1 "2009-11-13T06:53:47Z")

</div>

dear all  
how to find records which are 2 days older than from current date.  
i have a date field in my table.  
any exmaple pls…

---

<div class="post-metadata">

**Author:** ![newb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/2acd7d/32.png) [@newb](https://www.ruby-forum.com/u/newb)\
**Post date:** [November 13, 2009, 7:14am UTC](https://www.ruby-forum.com/t/how-to-find-records/178899/2 "2009-11-13T07:14:56Z")

</div>

Hi

```
Just an example here

```

records=Model.find :all, :conditions=\>["created\_on \< ? ",2.days.ago]

Sijo

---

<div class="post-metadata">

**Author:** ![newb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/2acd7d/32.png) [@newb](https://www.ruby-forum.com/u/newb)\
**Post date:** [November 13, 2009, 7:45am UTC](https://www.ruby-forum.com/t/how-to-find-records/178899/3 "2009-11-13T07:45:02Z")

</div>

Sijo k g wrote:

> Hi
> 
> ```
> Just an example here
> 
> ```
> 
> records=Model.find :all, :conditions=\>["created\_on \< ? ",2.days.ago]
> 
> Sijo

pls if i want to get file how i supposed to do

---

<div class="post-metadata">

**Author:** ![newb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/2acd7d/32.png) [@newb](https://www.ruby-forum.com/u/newb)\
**Post date:** [November 13, 2009, 11:42am UTC](https://www.ruby-forum.com/t/how-to-find-records/178899/4 "2009-11-13T11:42:10Z")

</div>

2009/11/13 Newb N. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid):

> pls if i want to get file how i supposed to do

What do you mean by ‘get file’? The above code does what you asked,  
finding all records older than two days.

Colin