I imported dates in from Access into SQL Server and had to convert them to nvarchar (importing errors)...my dates all say (example) 11/24/1977, etc., but are in nvarchar format. I'm trying CONVERT but get the arithmetic overflow error. I'm assuming I need to format the nvarchar numbers and slashes and remove the slashes (?) and then convert?
Basically, how do I get the NVARCHAR 11/24/1977 to DATETIME format in SQL?