>>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?
>
>You may try to pre-process the XML document as proposed in Message #701408

Hi Antonio. I need a more generic solution. Since I don't use datetime types at all, I've created a wrapper around XMLTOCURSOR to remove the time portion using STRTEAN

tcRecord = STRTRAN(tcRecord,'T00:00:00.0000000-07:00','')

Oh my aching CPU.