>>>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.
If you are confident that the time portion will allways come as 0 hour and from that particular timezone, your solution is much simpler and wiser. I'm sure your CPU is cool now.
----------------------------------
António Tavares Lopes