>>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.

Since the datatime type is close to a date, it seems to me that XMLTOCURSOR should figure this out and truncate the data. Not sure if I should report this as a bug, or submit this to the wishlist.