>>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.
I'd like to have a date, instead of datetime. I've tried to force ASP.NET to send back a date, but have failed so far.