hi,\ how do i get all records form my model, which are not older than 3 days ? Say i have column in my users table ''sign_in_date'', i want retrieve all records with sign_in_date not older than 3 days from now. thx regards --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
three_days_ago = (DateTime.now - 3.days) YourModel.find(:all, :conditions => [''sign_in_date > ?'', three_days_ago]) On Nov 17, 11:29 pm, Piotr Nowak <p.now...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> hi,\ > > how do i get all records form my model, which are not older than 3 days > ? Say i have column in my users table ''sign_in_date'', i want retrieve > all records with sign_in_date not older than 3 days from now. > > thx > > regards--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Jean-Sébastien pisze:> three_days_ago = (DateTime.now - 3.days) > YourModel.find(:all, :conditions => [''sign_in_date > ?'', > three_days_ago]) >3.days lol :) great stuff man --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---