Rails ActiveRecord Query Date Range

Question

I'm trying to use the following line in my controller to capture all tasks due less than a week from the current date:

@due_this_week = current_user.tasks.where(due_date: Date.today..1.week.from_now)

For some reason it's not finding any results even I know I have tasks due within four and six days. This is the only instance variable using a range query. I have another one that works fine to find overdue tasks:

@overdue = current_user.tasks.where("due_date <= ?", Date.today)

What am I missing?

Prem · Accepted Answer · 2016-07-28 13:33:42Z

98

Should be:

@due_this_week = current_user.tasks.where(due_date: 1.week.ago..Date.today)

edited Jul 28, 2016 at 13:33

Prem

6,0043 gold badges28 silver badges24 bronze badges

answered Dec 6, 2013 at 0:28

NARKOZ

28.2k7 gold badges71 silver badges91 bronze badges

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

4 Comments

mu is too short Over a year ago

How does that match "all tasks due less than a week from the current date"?

NARKOZ Over a year ago

OP made a mistake, sorry.

fatfrog Over a year ago

Sweet. That's all.

fatfrog Over a year ago

It's been a while since I up voted this bad boy, and it came in handy again today!

Bruno Degomme · Accepted Answer · 2022-12-01 08:13:59Z

5

FYI you can also use one sided ranges.

For all calls with due date from 1 week ago

@due_this_week = current_user.tasks.where(due_date: 1.week.ago..)

or for all calls with due date up to today

@due_this_week = current_user.tasks.where(due_date: ..Date.today)

answered Dec 1, 2022 at 8:13

Bruno Degomme

1,17311 silver badges11 bronze badges

Comments

Cody Barr · Accepted Answer · 2013-12-06 12:42:55Z

1

Turns out my controller somehow wasn't set up correctly and was no longer saving the current_user's ID when creating new assignments, which is why they weren't being found. I figured this out using the rails console and running a find on the last few assignments submitted. The user_id was set to nil. Thanks for the assist @mu is too short.

answered Dec 6, 2013 at 12:42

Cody Barr

6311 gold badge5 silver badges9 bronze badges

Collectives™ on Stack Overflow

Rails ActiveRecord Query Date Range

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related