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" <ri**@yc.edu> news:01****************************@phx.gbl...

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

[rick]

Shawn; Thanks! That is exactly what I needed.

rick

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

"rick" <ri**@yc.edu> news:018501c37afe$585df3e0

$a*******@phx.gbl...

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

.