Ruby on Rails - Date Comparison

Question

I am trying to compare dates for an app in rails. I have tried this link Comparing dates in rails. But this is not what I want, suppose I have a filter according to dates, then I am doing

<% jobs = @user.jobs.where(:curr_date => (Date.today))%>

Here, curr_date is a "date" attribute chosen by me.

This code works for entries which have today's date, but if I want all entries which have date between today and a week before, what should I do?

Thanx! :)

Draiken · Accepted Answer · 2012-07-10 12:41:15Z

2

You can simply use

jobs = @user.jobs.where(:curr_date => (DateTime.now..1.week.ago))

Updated to DateTime.now or you can also use Date.today.to_time otherwise there will be an error for comparing a Date and a Time

edited Jul 10, 2012 at 12:41

answered Jul 10, 2012 at 11:33

Draiken

3,8052 gold badges32 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Draiken Over a year ago

Also note, that doing this on the view (as your question sugests) is not good practice

Vatsal Singh Over a year ago

thanx for replying, but I get some "bad value for range" error. Instead, I tried: <% jobs = @user.jobs.all(:conditions =>['curr_date > ?',Date.today-7])%> and it worked for me. :) Kindly tell me the intricacies involved, if possible.

moritz Over a year ago

Just use (Date.today.to_time..1.week.ago) instead.

ABrukish · Accepted Answer · 2012-07-10 11:31:30Z

1

I think something like that should work:

<% jobs = @user.jobs.where(['curr_date < ? AND curr_date > ?', Date.today, 1.week.ago])) %>

answered Jul 10, 2012 at 11:31

ABrukish

1,4621 gold badge9 silver badges9 bronze badges

2 Comments

Soundar Rathinasamy Over a year ago

I think the code has minor mistake.It should be ['curr_date <= ? AND curr_date >= ?', Date.today, 1.week.ago]

ABrukish Over a year ago

Well, the question is was it opened or closed interval :)

vamsi · Accepted Answer · 2012-07-10 11:43:25Z

1

comparison_date_1 <=> comparison_date_2 might be useful to to you which returns -1,1,0 accordingly and you can populate them......

answered Jul 10, 2012 at 11:43

vamsi

939 bronze badges

Comments

Kashyap · Accepted Answer · 2012-07-10 18:11:39Z

0

Haven't tried this in a console but I think it should work:

# You need to implement the #week_before method
@user.jobs.where(:curr_date => (Date.week_before..Date.today))

Active Record Querying - Array Conditions Check under Range conditions (2.2.2)

edited Jul 10, 2012 at 18:11

answered Jul 10, 2012 at 11:34

Kashyap

4,80628 silver badges27 bronze badges

1 Comment

deefour Over a year ago

The IN is not valid syntax, that should be =>

Collectives™ on Stack Overflow

Ruby on Rails - Date Comparison

4 Answers 4

3 Comments

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related