title: TRY_CONVERT returns NULL on a value that looks like a date
body: <p>I have been benefiting from <code>TRY_CONVERT</code> function thanks to <a href="https://stackoverflow.com/questions/55185477/which-values-are-making-the-conversion-from-varchar-to-date-fail">a reply from my last question</a>. </p>
  
  <p>I am now facing a value in a key/value table (the value column of type <code>NVARCHAR(50)</code>) that cannot be converted to <code>DATE</code> even though it very much looks like a date.</p>
  
  <p><a href="https://i.stack.imgur.com/36P0u.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/36P0u.png" alt="enter image description here"></a></p>
  
  <p>I'd like to why <code>TRY_CONVERT(DATE, [Claim issue complete])</code> should return a <code>NULL</code>.</p>
  
  <p>Even though I use a substring of the value like this the result is the same</p>
  
  <pre><code>SELECT SUBSTRING([Claim issue complete], 1, 10) AS CompletionDate
  </code></pre>
  
  <p><strong>UPDATE</strong>: A textual copy of the picture</p>
  
  <pre><code>Claim issue complete
  2018-09-21 00:00:00+02
  2017-10-12 00:00:00+02
  2018-01-30 00:00:00+01
  2017-07-19 00:00:00+02
  2019-02-14 00:00:00+01
  NULL
  2017-08-06 00:00:00+02
  2017-10-04 00:00:00+02
  2018-05-18 00:00:00+02
  2018-09-05 00:00:00+02
  2019-01-14 00:00:00+01
  2019-01-24 00:00:00+01
  2018-03-21 00:00:00+01
  2017-11-28 00:00:00+01
  2018-02-26 00:00:00+01
  2018-04-05 00:00:00+02
  2018-04-27 00:00:00+02
  </code></pre>
  
  <p><strong>Update 2</strong>: An Example</p>
  
  <p>Here is a sample of the problem.</p>
  
  <pre><code>SELECT TRY_CONVERT(DATE, '2018-09-21 00:00:00+02')
  </code></pre>
  
  <p>The above returns <code>NULL</code>.</p>