title: String to Date Conversion inside Rails Where Clause
body: <p>I have a query like this:</p>
  
  <pre><code>User.where("medical_card_expiry_date BETWEEN ? AND ?",Time.now.to_date,(Time.now+10.years).to_date)
  </code></pre>
  
  <p>This query would have worked fine if the <code>medical_card_expiry_date</code> was in <code>Date</code> format,but unfortunately its a <code>String</code> and hence will not produce the expected result.</p>
  
  <p>Can i convert the <code>medical_card_expiry_date</code> to <code>Date</code> insdide the where clause itself?Is there a method in Rails so that I could make this work?</p>