title: using sql MONTH or YEAR in cakephp find queries
body: <p>I'm trying to get all the users that has registered during a particular month using a query like this in a cakephp application:</p>
  
  <pre><code>$registered_users = $this-&gt;User-&gt;find('all', array(
      'conditions' =&gt; array(
          'MONTH(User.date)' =&gt; 10
      )
  ));
  </code></pre>
  
  <p>The query above is supposed to return me all the users that has registered during the month of october for example, but for some reason, I get the following error:</p>
  
  <pre><code>1054: Unknown column 'User.date' in 'where clause'
  </code></pre>
  
  <p>Does anybody know why I'm getting this error please?</p>
  
  <p>Thank you</p>