I have imported data into a table from excel. I have two date fields that came in as nvarchar 255. I'm trying to get those into datetime format. I tried creating two new fields in my table that are datetime. then doing and update statement to move the values into these fields.
When I do that I get: The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
I get the same message when trying to import the data from excel and on the edit mappings changing the field type to datetime. I have also tried different formats in excel with no luck.
The value in the date fields look like; 2013-04-01 00:00:14