title: mysql max(date) not working
body: <p>So i have this query that is supposed to return some information like price, open, close, etc.. for the LATEST entry.</p>
  
  <pre><code>SELECT * FROM History WHERE symbol = $symbol Having max(`date`);
  </code></pre>
  
  <p>But for whatever reason its not returning the correct information. It for some reason believes that the max date is 2013-02-14, but if i look at all the data the most recent is actually 2013-02-27.
  in this particular case</p>
  
  <pre><code>$symbol = "AGNC"
  </code></pre>
  
  <p>Does the max function not work on date?</p>