Converting String to Date format in MS Access
<p>I have field which show the month and year in a string format. How can I convert it into MMYYYY format in Microsoft Access?</p>

<p>The field values are as follows:</p>

<pre><code>Period Code
M01-15
M02-15
M03-15
M04-15
M05-15
</code></pre>

<p>The above values are sent by the client.</p>

<p>I want to get the values in any date format preferably in MMYYYY.</p>

<p>The result should be as:</p>

<pre><code>Period Code
012015
022015
032015
042015
052015
</code></pre>

<p>Can anyone suggest me how can I get the desired result? </p>