title: How to alter a date field into a specific format
body: <p>I have a field called GR date.  The values look like this:</p>
  
  <p>20171031
  20170922
  20170803
  20170707
  20170626</p>
  
  <p>I want to manipulate the values into a new field in a specific format.  The new field is called Reporting Period and the values would look like this:</p>
  
  <p>10 2017
  9 2017
  8 2017
  7 2017
  6 2017</p>
  
  <p>I have the Access code to create the field, but I am trying to do this in T-SQL and the DateSerial and Mid functions do not work in there.  How can I re-write this?</p>
  
  <pre><code>Reporting Period: Month(DateSerial(Left([GR Date],4),Mid([GR Date],5,2),Right([GR Date],2))) &amp; " " &amp; Year(DateSerial(Left([GR Date],4),Mid([GR Date],5,2),Right([GR Date],2)))
  </code></pre>