title: cakephp find records last 24 hours
body: <p>How can I find the Users that are "last_seen" the last 24hours?</p>
  
  <pre><code>[User][last_seen] =&gt; 2012-08-18 08:10:31
  </code></pre>
  
  <p>last_seen is updated each time a logged in user browse the website with current timestamp</p>
  
  <p>This is what I have tried this far:</p>
  
  <pre><code>$users = $this-&gt;User-&gt;find('all',array('conditions'=&gt;array('User.last_seen &gt;' =&gt;'BETWEEN NOW() AND NOW()- INTERVAL 24 HOURS'),'recursive'=&gt;-2));
  </code></pre>
  
  <p>But my array is coming back empty.</p>
  
  <p>Suggestions??</p>
  
  <p>As always!! You are awesome! Thanks for your time!</p>
  
  <p>-Tom</p>