title: Date Format - Change format of Month from String to Numeric Value
body: <p>I would think this is relatively straight forward but cant find documentation on how to do it(or the correct syntax to use) and my messing around hasn't worked so far.</p>
  
  <p>For Dates we have a custom format called Month /Day /Year. This pulls back a the date(as a date type) in date format as such:</p>
  
  <p>"14 April 2003"</p>
  
  <p>The code behind this is:</p>
  
  <pre><code>(DATEPART('year', [Close Date])*10000 + DATEPART('month', [Close Date])*100 + DATEPART('day', [Close Date]))
  </code></pre>
  
  <p>What I want to get back is the month is numeric format like:</p>
  
  <p>"14.04.2003"</p>
  
  <p>Is it simply changing the "month" part in the code to a different type? Has any one come across this?</p>
  
  <p>Cheers</p>