title: Error: The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value
body: <p>I know that there are simmilar questions like this on the forum, however I am still having problems to update a datetime field o the database. I dont get any problems when inserting but I get problems when updating and I am formating the same way , like this:</p>
  
  <blockquote>
    <p>e.Values.Item("SelectionStartDate") = Format(startdate, "yyyy-MM-dd")
    + " " + startTime1 + ".000"</p>
  </blockquote>
  
  <p>startTime is of type string.</p>
  
  <p>I have tried different solution that I came across on the internet but still get this error.
  Please help.</p>
  
  <p>Thanks in advance</p>