Conversion from String to type Date is not valid error

Question

I have the following date as string "091020". I am using SubSonic as my DAL. When I do

myObject.DateColumn = "091020"

I get the error "Conversion from type String to Type Date is not valid"

I tried playing with the IFormatProvider and CultureInfo but can't seem to get raid of the error.

What am I missing?

Answer 1

Try

myObject.DateColumn = DateTime.ParseExact("091020", "yyMMdd", null)

DateTime.ParseExact lets you specify exactly how to parse the date when it's not entirely obvious.

Answer 2

.Net can't parse that into a valid date. Throw this in a new project and verify that:

string sDate = "091120";
DateTime dt = DateTime.MinValue;

if (DateTime.TryParse(sDate, out dt))
    MessageBox.Show(dt.ToShortDateString());
else
    MessageBox.Show("Nope");

So, if you KNOW that all your dates are yyMMdd, then use this:

DateTime.ParseExact("091120", "yyMMdd", null)

How are you getting these dates? Are they guaranteed to be 6 digits in the yyMMdd format?