title: SQL DateKey to normal Date
body: <p>I have an SQL DateKey that looks like this </p>
  
  <pre><code>YYYYMMDD
  </code></pre>
  
  <p>This was created using </p>
  
  <pre><code>Convert(varchar,[ModifiedOn],112))
  </code></pre>
  
  <p>However I want this field in a view to display the normal dateformat in the UK as DD-MM-YYYY</p>
  
  <p>how can I do that.</p>
  
  <p>Thank you.</p>