Hi Evan,
You can try to pre-build cursor with date type for that field and run XMLTOCURSOR() with 8192 flag (use existing cursor).
>>>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.
--sb--