From: Taneal Bhandari Date: 2009-04-22T05:43:07+09:00 Subject: Re: comparing date problem Taneal Bhandari wrote: > now = Time.now > @events = Event.find(:all, :conditions => ["event_date > " + now.to_s, > {:venue_id => @venue.id}]) Actually, I just realized that I also have to take into consideration "event_time". Our table has 2 fields event_date and event_time, and I only want to pull back records of events where both the event_date and event_time have not passed. I've been playing around with it for a bit, but it doesn't like any combination that I've tried. Any thoughts? -- Posted via http://www.ruby-forum.com/.