title: Convert string with Year and Month ONLY... to the date format for Year and Month only
body: <p>Bit of a weird ask, but I have rows and rows of year/months as a string and i'm trying to convert it into date format.</p>
  
  <p>Not too sure this can be done as it's not a full date but worth an ask.</p>
  
  <pre><code>UPDATE table
  SET [Year Month] = CONVERT (DATE, [Year Month], 103)
  </code></pre>
  
  <p>Returns </p>
  
  <pre><code>Conversion failed when converting date and/or time from character string.
  </code></pre>
  
  <p>String of data looks like this:</p>
  
  <pre><code>|Year Month|
  | 2015-02  |
  | 2016-06  |
  | 2016-01  |
  | 2020-09  |
  </code></pre>
  
  <p>Have seen other posts but they all stem from having the full date already and just essentially cutting of the day to grab the year month etc. but in this case its only year and month that I have as a string and is needed to format into date year and month</p>