title: How to get rid of the following error? Converting date from string is failed
body: <p>In SQL Server, I am getting the error:</p>
  
  <blockquote>
    <p>Error -2147217913: Conversion failed when converting date an/or time from character string. </p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/RgRtg.jpg" rel="nofollow noreferrer">Error in converting</a></p>
  
  <p>I am sure that my fields are in date field, but why this error keeps on showing?</p>
  
  <p>First I validated first if the data type is really a date column:</p>
  
  <pre><code> CASE 
      WHEN ISDATE(dbo.AdditionalDetailInfo.UserDefined2) = 1 
         THEN dbo.AdditionalDetailInfo.UserDefined2 
         ELSE NULL 
   END AS ReceivedDate
  </code></pre>
  
  <p>I found out that yes, it's correct. so i proceed with converting this field where UserDefined2 value should always be plus 1 day.</p>
  
  <pre><code>CONVERT(VARCHAR(12), DATEADD(DAY, 1, CONVERT(DATETIME, dbo.AdditionalDetailInfo.UserDefined2)), 103) AS ReceivedDate
  </code></pre>
  
  <p>Please let me know if there's something wrong with my query as I really can't diagnose what went wrong.</p>
  
  <p>See screenshot:</p>
  
  <p><a href="https://i.stack.imgur.com/UnhJU.jpg" rel="nofollow noreferrer">See this link, the actual data and in SQL server + 1 day</a></p>