All dates are within those ranges you specified.

I have used the SET DATEFORMAT dmy as you said.

Default language us_english

still I have failure, does this stored proc look ok?

@i_XML TEXT

AS

Declare @id...

I'm still getting the same problem.

My xml looks like this:

<?xml version="1.0" encoding="UTF-8"?>

<ADS>

<ADS_CREATE_TIME>2005-04-13T20:45:31</ADS_CREATE_TIME>

<AD URN="CH100" CAT="Motors">

<TRADE_STYLE>1</TRADE_STYLE>

<ORDER_VALUE_NET>232.7</ORDER_VALUE_NET>

<ORDER_VALUE_GROSS>273.42</ORDER_VALUE_GROSS>

<ORDER_CREATION_DATE>29/03/05</ORDER_CREATION_DATE>

<ORDER_CREATION_SOURCE>Lynne.Bradley</ORDER_CREATION_SOURCE>

<PUBS>

<PUB>

<PUB_NAME>BCA</PUB_NAME>

<CLASS>Car Auctions</CLASS>

<STYLE>Display</STYLE>

<PAGE_GROUP>Motors</PAGE_GROUP>

<FIRSTINS>01/04/05</FIRSTINS>

<LASTINS>15/04/05</LASTINS>

<ADTEXT>PLACE ON PAGE THREE</ADTEXT>

</PUB>

</PUBS>

<AREAS>

<AREA>NW</AREA>

</AREAS>

<ADLOCATION>

<TOWN>Frodsham</TOWN>

<COUNTY>Cheshire</COUNTY>

<PC>WA6 0ES</PC>

</ADLOCATION>

<VENDOR>

<VENDOR_NAME>Bradley, Mrs Lynne</VENDOR_NAME>

<VENDOR_TEL>01928 724370</VENDOR_TEL>

<VENDOR_FAX> </VENDOR_FAX>

<VENDOR_COMPANY_ID/>

<VENDOR_EMAIL/>

<ADDRESS>36 Hill View Ave, Helsby</ADDRESS>

<TOWN>Frodsham</TOWN>

<COUNTY>Cheshire</COUNTY>

<PC>WA6 0ES</PC>

<COUNTRY>United Kingdom</COUNTRY>

</VENDOR>

</AD>

</ADS>

thanks for...