title: Retrieve last 3 years of data with custom date
body: <p>Here's my query:</p>
  
  <p><code>mysql&gt; select * from jobs where datediff(now(),str_to_date(last_modified,'%M %d,%Y'))&gt;=1095;</code></p>
  
  <p>I get 0 results</p>
  
  <p>mysql> select max(last_modified) from jobs;</p>
  
  <pre><code>+--------------------+
  | max(last_modified) |
  +--------------------+
  | 9/9/2013           |
  +--------------------+
  1 row in set (0.06 sec)
  
  mysql&gt;
  </code></pre>
  
  <p>It doesn't seem to be working to well and Im not sure why. <code>I think it has to do with the original formatting of the last_modified column</code></p>
  
  <p><strong>UPDATE</strong></p>
  
  <pre><code>mysql&gt; select distinct(last_modified) from jobs where datediff(now(),str_to_date(last_modified,'%m/%d/%Y'))&gt;=1095 limit 10;
  
  +---------------+
  | last_modified |
  +---------------+
  | 12/4/2003     |
  | 12/5/2003     |
  | 12/6/2003     |
  | 12/8/2003     |
  | 12/9/2003     |
  | 12/10/2003    |
  | 12/11/2003    |
  | 12/12/2003    |
  | 12/13/2003    |
  | 12/14/2003    |
  +---------------+
  10 rows in set (0.00 sec)
  
  mysql&gt;
  </code></pre>