datetime string conversion

[rick]

We recently converted a legacy database to SQL Server.
A field in legacy contained a start and end date range
example mmddyy-mmddyy. This information was converted
into a SQL character string. I must use the SQL column to
do date comparisions, addition and store in a true date
format in another table. I did a split into two separate
strings then tried using convert.todatetime, parse etc.
but I just can't get it to work. Can someone give me an
example?

thanks

 

[Shawn]

try this
string format = "MMddyy";
DateTime date = DateTime.ParseExact(str,format,null);

 

[rick]

Shawn; Thanks! That is exactly what I needed.

rick