This will be my last question for today as I need to do some studying!!
I referred to this in a previous question, but now need to know how to do it. I'm importing from Excel into SQL Server and it brings the dates in as nvarchars. I'm then performing some stuff on those date but the results are incorrect and I think it might be because they are nvarchars not dates.
I've tried various ways of converting them but have had no success. Please can someone give me some guidance?