# Query that display the list for todays records

**URL:** <https://www.ruby-forum.com/t/query-that-display-the-list-for-todays-records/159195>\
**Category:** Rails\
**Created:** [February 2, 2009, 9:37am UTC](https://www.ruby-forum.com/t/query-that-display-the-list-for-todays-records/159195 "2009-02-02T09:37:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![johnroyworld](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/bcef8e/32.png) [@johnroyworld](https://www.ruby-forum.com/u/johnroyworld)\
**Post date:** [February 2, 2009, 9:37am UTC](https://www.ruby-forum.com/t/query-that-display-the-list-for-todays-records/159195/1 "2009-02-02T09:37:18Z")

</div>

hello all,

How do i make a query on active records that would display the list of  
all records that happened on this day or lets says today’s transaction  
records.

“Datetime” is my data type of the field on the database. Any help /  
advice will be appreciated.

Thank you

---

<div class="post-metadata">

**Author:** ![johnroyworld](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/bcef8e/32.png) [@johnroyworld](https://www.ruby-forum.com/u/johnroyworld)\
**Post date:** [February 2, 2009, 11:39am UTC](https://www.ruby-forum.com/t/query-that-display-the-list-for-todays-records/159195/2 "2009-02-02T11:39:13Z")

</div>

On Mon, Feb 2, 2009 at 10:37 AM, Johnroy W. \<  
removed\_email\_address@domain.invalid\> wrote:

> ## Thank you
> 
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).
> 
> >

Model.find(:all, :conditions =\> {:created\_at =\>  
(Time.now.beginning\_of\_day…Time.now.end\_of\_day)})

–  
Andrew T.  
[http://ramblingsonrails.com](http://ramblingsonrails.com)  
[http://www.linkedin.com/in/andrewtimberlake](http://www.linkedin.com/in/andrewtimberlake)

“I have never let my schooling interfere with my education” - Mark Twain