You receive error event ID 324 when parsing dates

Problem

When you use the Database Value Extractor functoid in a map to extract a date field, your document may fail validation against the outbound document definition. BizTalk Server may log a validation error similar to the following in the event log:

Event Source: BizTalk Server

Event Category: Document Processing

Event ID: 324

Description:

An error occurred in BizTalk Server.

Details:

------------------------------

The XML document has failed validation for the following reason: Error parsing '10/12/1995' as date datatype.

Suspended Queue ID: "{A1127909-CA36-4359-B672-7CBA8B60BDAF}"

Cause

The date format (as it is returned from the data source) is not in ISO 8601 format, which is the format required by XML.

Resolution

To resolve this issue, do one of the following:

· Edit your outbound document definition to use a string datatype instead of a date datatype.

· Create a custom Microsoft Visual Basic Script functoid that will convert the output of the Database Value Extractor functoid into the ISO 8601 format.

Source: Microsoft