Vb.net IsDate() Question

Hi,

I have a package with a script task. I need to check incoming values from a file to make sure they're dates. I read the file in as one line, then create output columns. Hence, that is why I refer to the AcquistionDate field as array value 5, as this is the 6th column in the file.

In my connection manager, output columns, I have AcquisitionDate field defined as a STRING, length 10. In the flat file, dates look like this: "2007-08-23". I remove the "" with the String.Empty.

So, then I do an IsDate check.

Here is my code:


'Check date columns for date values

If IsDate(rowValues(5)) Then

Row.AcquisitionDate = rowValues(5).Replace("""", String.Empty)

Else

Row.AcquisitionDate_IsNull = True

End If


Problem is, IsDate is evaluating to FALSE. That is, execution goes to the Else portion, and sets all the AcquistionDates to NULL.

What am I doing wrong here?

Thanks