Convert nvarchar data to datetime

[debbiepy]

I get two differ data files from our source with dates in these two types of format

yyyymmdd ddd, mmm dd, yyyy

20050215 Sun, Feb 12, 2005

I get in a *.csv or txt file and then import it into our sql server database as an nvarchar field (cuz it would not import as a date field). I use EMS MS SQL Manager pro to import the data. I then want to use these as a date field in Crystal Reports. How can I do this so I can sort properly by date?

 

[Madawc]

Try Date({your.field}). It mostly works for converting text to a true date. Display the result and see what you get.

Madawc Williams (East Anglia, UK)