>I'm getting some XML passed into my VFP COM component from as ASP.NET page. The XML has dates in the form
>
>
><xs:element name="date_in" type="xs:date" />
><date_in>2002-08-01T00:00:00.0000000-07:00</date_in>
>
>
>When I use XMLTOCURSOR(tcRecord,"cRecord",4) the date (datetime) field above is interpreted as {} instead of {^2002/08/01}. Anyone know how to correct this?
The schema is specifying a "date" datatype, but the data in the
element is in the format for xsd:dateTime. Correct the schema to specify the dateTime datatype, and it should work fine.