title: Order by descending date - month, day and year
body: <p>This seems stupid but, I simply need a list of dates to be ordered with the most recent date at top. Using <code>order by DESC</code> doesn't seem to be working the way I want it to.</p>
  
  <pre><code>SELECT     *
  FROM         vw_view
  ORDER BY EventDate DESC
  </code></pre>
  
  <p>It gives me the date ordered by month and day, but doesn't take year into consideration.
  for example:</p>
  
  <pre><code>12/31/2009 
  
  12/31/2008
  
  12/30/2009
  
  12/29/2009
  </code></pre>
  
  <p>Needs to be more like:</p>
  
  <pre><code>12/31/2009
  
  12/30/2009
  
  12/29/2009
  
  12/28/2009
  </code></pre>
  
  <p>and so on.</p>