Date Format - Change format of Month from String to Numeric Value
<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>