Ruby on Rails Sunday, January 29, 2017

On Sunday, January 29, 2017 at 1:29:03 PM UTC-5, Joe Guerra wrote:
I'm trying to figure out how to compare my enddate > in my where clause.

enddate is a date field, I'm just trying to only display products that haven't expired (by the date field).

I've tried...

require 'time'

products.where(['enddate > ?',]) 

ok, I've kind of figured it out.  but I need to combine my where clause now...

require 'time'

todaydate =
# set 'todaydate' equal to the current date/time.

todaydate = todaydate.year.to_s + "-" + todaydate.month.to_s + "-" +

@title =
@products = @category.products.where( 'draft' => false, 'active' => true, 'funded' => false)

    @products = @category.products.where('enddate > ?', todaydate ) 

You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
To post to this group, send email to
To view this discussion on the web visit
For more options, visit

No comments:

Post a Comment