XML elements of type date generate errors when data is blank or 00/00/0000

Hi,

Here’s an error I am getting when validating a flatfile against its schema,

“The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar”

This error is showing up for elements with datatype: “xs:date” and custom format: “MM/dd/yyyy”

The error occurs when data value is blank or in one case when the data was 00/00/0000.

For blank data, I set the Nillable property to “True” but still gave the same error.

Also, tried giving a default value in the date format but the it was still giving out the same error.

Note: the flatfile source is a mainframe system where its not
possible to fix the data and has to be done at my end. Also, I am trying
to avoid to use a map with a scripting functoid for each date type
element, since the current doesn’t need one, if not
for this issue.

Please do let me know how do I fix this? All help is greatly appreciated.

Thanks.

Ajay Kallur

[email protected]