Hrmm.. Ok, I don't know that much about SQL-Server, being an ASP-developer myself, but I have a problem. I have a field, nvarchar-format, containing dates in UK format, like 'dd/mm/yyyy'. Now I want to convert this to datetime format, since I have to sort by this column, but when I try to convert I get an error message: "Arithmetic overflow error converting expression to data type datetime.".
I could solve this ASP-style, by writing a function that read every value from the database, converted the textstring to a mm/dd/yyyy format, and then try to convert again. But I'd rather not.. Does anyone have a better idea on how to solve this?
I wrote an asp-thingy that converts the date to American format, and after that I can convert the field to datetime in Enterprise Manager, and it turns up as UK dates. Weird, but works. Thanks anyway..