title: Order by latest date
body: <p>SQL</p>
  
  <pre><code>SELECT 
     CONVERT(VARCHAR, EffectiveTo, 105) as EffectiveTo 
  FROM 
     CSchedules 
  WHERE 
     CId = 3278 
  ORDER BY 
     EffectiveTo ASC
  </code></pre>
  
  <p>Dates</p>
  
  <pre><code>03-08-2014
  03-09-2017
  03-09-2017
  03-09-2017
  09-11-2014
  14-12-2014
  16-11-2014
  16-11-2014
  20-07-2014
  20-12-2015
  23-11-2014
  24-08-2014
  27-12-2015
  27-12-2015
  30-11-2014
  31-08-2014
  31-08-2014
  31-08-2014
  </code></pre>
  
  <p>I need to order by date so that:</p>
  
  <pre><code>03-09-2017
  </code></pre>
  
  <p>is the first in the list. However it does not order properly. Basically the latest date first.</p>
  
  <p>When ordered by DESC:</p>
  
  <pre><code>31-08-2014
  31-08-2014
  31-08-2014
  30-11-2014
  27-12-2015
  27-12-2015
  24-08-2014
  23-11-2014
  20-12-2015
  20-07-2014
  16-11-2014
  16-11-2014
  14-12-2014
  09-11-2014
  03-09-2017
  03-09-2017
  03-09-2017
  03-08-2014
  </code></pre>