title: Yet Another "Conversion Failed When converting date and/or time from character string" issue
body: <p>Datetime string is in this format:   <code>2017-03-07T16:17:59.000+0000</code></p>
  
  <p>I have tried over a dozen examples I've found online and here, but all result in the same (or nearly the same) error message.  </p>
  
  <p>Some things I have tried: </p>
  
  <pre><code>select CONVERT(datetime2, Create_Date, 103), * from dev.dbo.ticket_Data 
  where assignee = 'eric king'
  
  Select CONVERT(int, replace([Create_Date],'.0000+0000',''))Resolution_Date, * from dev.dbo.ticket_Data 
  where assignee = 'eric king'
  
  select lEFT([Create_Date],LEN([Create_Date] - 9)), Resolution_Date, * from dev.dbo.ticket_Data 
  where assignee = 'eric king'
  
  
  select DateDiff(d, Convert(Create_Date), Convert(Resolution_Date)), * from dev.dbo.ticket_Data 
  where assignee = 'eric king'
  </code></pre>
  
  <p>EDIT:
  After finding some bad data in the column, the issue was resolve.  It was not tied to the attempts or date format, but the bad data.  I used this and it works as expected now. </p>
  
  <pre><code>Select convert(datetime,Left(Replace(Create_Date, 'T', ' '), 19)), * from dev.dbo.ticket_data 
  </code></pre>