title: Get a first and last day of the month from month key
body: <p>I have a month key which look like this <code>"201208"</code>.</p>
  
  <p>I am reading the data from SQL and returning as a <code>DataTable</code>.
  Then I am looping through my <code>DataTable</code>.</p>
  
  <pre><code>For Each dr As DataRow In dt.Rows
     Dim s As String = dr.Item(0)
  Next
  </code></pre>
  
  <p>My <code>s</code> would be a string looking like this <code>"201208"</code>
  How convert this string into <code>year, first day of the month and last day of the month</code>?<br /><br />
  <strong>Looking for a way to split the string into two seperate <code>dim</code>s.</strong></p>
  
  <p>Any suggestions much appreciated.</p>