# Ruby on Rails Dates

**URL:** <https://www.ruby-forum.com/t/ruby-on-rails-dates/157691>\
**Category:** Rails\
**Created:** [January 14, 2009, 1:34pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-dates/157691 "2009-01-14T13:34:57Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rpierry](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e19adc/32.png) [@rpierry](https://www.ruby-forum.com/u/rpierry)\
**Post date:** [January 14, 2009, 1:34pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-dates/157691/1 "2009-01-14T13:34:57Z")

</div>

Hi,

I am using a MySQL database and have a row callsed date in my fixtures  
table. I am wanting to display fixtures coming up, i.e. ahead of todays  
date.

In my controller I am thinking of doing;  
@fixtures = Fixtures.find(:all, :conditions =\> "date \> #{Date.today} ",  
:order =\> “id DESC”)

Do dates work this way, is this the correct way to go about it?

Also, are there any forum systems built with Ruby on Rails that I can  
download for use on my site?

Thanks in advance, Rob

---

<div class="post-metadata">

**Author:** ![rpierry](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e19adc/32.png) [@rpierry](https://www.ruby-forum.com/u/rpierry)\
**Post date:** [January 14, 2009, 1:43pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-dates/157691/2 "2009-01-14T13:43:19Z")

</div>

as for forum software:  
[http://rforum.andreas-s.net/](http://rforum.andreas-s.net/)

your idea with dates should work, too.

---

<div class="post-metadata">

**Author:** ![rpierry](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e19adc/32.png) [@rpierry](https://www.ruby-forum.com/u/rpierry)\
**Post date:** [January 14, 2009, 1:59pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-dates/157691/3 "2009-01-14T13:59:48Z")

</div>

On Jan 14, 2009, at 7:34 AM, Rob Pa wrote:

> :order =\> “id DESC”)
> 
> Do dates work this way, is this the correct way to go about it?

At least, I’d change this to:

@fixtures = Fixture.find(:all, :conditions =\> [‘data \> ?’,  
Date.today],  
:order =\> ‘id DESC’)

But it would be better to put this into a named scope:

class Fixture  
named\_scope :future, lambda { {:conditions =\> [‘data \> ?’,  
Date.today]} }  
end  
then, in your controller  
@fixtures = Fixture.future

> Also, are there any forum systems built with Ruby on Rails that I can  
> download for use on my site?
> 
> ## Thanks in advance, Rob

I was about to give you a couple answers, but then I re-read your  
question. I’m not sure about forums, but there are certainly a few  
options for wikis.

[LMGTFY - Let Me Google That For You](http://letmegooglethatforyou.com/?q=ruby+rails+forum+software)

-Rob

Rob B. [http://agileconsultingllc.com](http://agileconsultingllc.com)  
removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![rpierry](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e19adc/32.png) [@rpierry](https://www.ruby-forum.com/u/rpierry)\
**Post date:** [January 14, 2009, 2:03pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-dates/157691/4 "2009-01-14T14:03:56Z")

</div>

## And [GitHub - radar/rboard: A fully featured forum system compatible with Rails 2.3](http://github.com/radar/rboard) - Fully supports Rails 2.2 and internationalisation.

Ryan B.  
Freelancer

> **[frozenplague.net](http://frozenplague.net)**
>
> This domain may be for sale!

---

<div class="post-metadata">

**Author:** ![rpierry](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e19adc/32.png) [@rpierry](https://www.ruby-forum.com/u/rpierry)\
**Post date:** [January 14, 2009, 5:13pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-dates/157691/5 "2009-01-14T17:13:05Z")

</div>

I don’t mean to be too intrusive as I am a dreadful IT Recruiter that  
you probably all despise. I am working on filling a number of RoR  
Developer positions for an exciting young company in NYC. If you are  
interested in learning more about the position please e-mail me,  
removed\_email\_address@domain.invalid or call me at 212.991.1835. No one has to  
know that you contacted me regarding and you can still bash me here in  
the blog.

Have a great day! Thanks!

Rob Pa wrote:

> Hi,
> 
> I am using a MySQL database and have a row callsed date in my fixtures  
> table. I am wanting to display fixtures coming up, i.e. ahead of todays  
> date.
> 
> In my controller I am thinking of doing;  
> @fixtures = Fixtures.find(:all, :conditions =\> "date \> #{Date.today} ",  
> :order =\> “id DESC”)
> 
> Do dates work this way, is this the correct way to go about it?
> 
> Also, are there any forum systems built with Ruby on Rails that I can  
> download for use on my site?
> 
> Thanks in advance, Rob

---

<div class="post-metadata">

**Author:** ![rpierry](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e19adc/32.png) [@rpierry](https://www.ruby-forum.com/u/rpierry)\
**Post date:** [January 14, 2009, 8:54pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-dates/157691/6 "2009-01-14T20:54:50Z")

</div>

Can’t you just send out an email, with [JOBS] in the subject? I don’t  
think anyone would be bothered by that. Don’t change a discussion  
subjects just for spite. Have some class.

On Jan 14, 11:13 am, Michael Michael \<rails-mailing-l…@andreas-