title: CodeIgniter active record compare a date
body: <p>I have a column in a db with a date stored as mm/dd/yyyy. I need to grab all the rows with dates greater than a certain date. (Ex. any date after 01/01/2013). How do I do this using active record?</p>
  
  <p>I have tried </p>
  
  <pre><code>$this-&gt;db-&gt;select('DATE_FORMAT(date, '%mm/%dd/%Y') as mydate');
  $this-&gt;db-&gt;where('mydate &gt;','01/01/2013');
  </code></pre>