How to catch the all objects with date 5 days from today?

Question

I am trying to do this using this scope:

>> Job.last.application_date
  Job Load (0.4ms)  SELECT "jobs".* FROM "jobs" ORDER BY created_at ASC LIMIT 1
=> Wed, 13 Feb 2013
>> Date.today + 5.days
=> Wed, 13 Feb 2013
>> Job.where(application_date: Date.today + 5.days)
  Job Load (0.2ms)  SELECT "jobs".* FROM "jobs" WHERE "jobs"."application_date" = '2013-02-13' ORDER BY created_at DESC
=> []

UPDATE

Hmm, that is not working, maybe because some data format.

>> Job.where("application_date = ?", Date.today + 5)
Job Load (0.3ms) SELECT "jobs".* FROM "jobs" WHERE (application_date = '2013-02-13') ORDER BY created_at DESC => [] 
>> Job.last.application_date Job Load (0.7ms)
 SELECT "jobs".* FROM "jobs" ORDER BY created_at ASC LIMIT 1 => Wed, 13 Feb 2013

# Schema jobs
#  application_date       :date

Answer 1

You can use:

where("application_date = ?", Date.today + 5)