title: Rails 3: Finding records with datetime 3 days from today
body: <p>I have the following Scope:</p>
  
  <pre><code>def coming_up_on_renewal(product_name = "product_name")
    where('billing_start_date = NOW() + INTERVAL 3 day AND status = ? AND product_name = ? AND auth_net_subscription_id IS NOT NULL', :active, "#{product_name}")
  end
  </code></pre>
  
  <p>And I have manipulated a single record in my database to be 3 days in the future, yet when I run this scope, an empty array is returned. </p>
  
  <p>I am basically trying to retrieve records where the <code>billing_start_date</code> is 3 days from the current day.</p>