Error: The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value
- by CPM
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:
e.Values.Item("SelectionStartDate") = Format(startdate, "yyyy-MM-dd")
+ " " + startTime1 + ".000"
startTime is of type string.
I have tried different solution that I came across on the internet but still get this error.
Please help.
Thanks in advance