I don't know, sounds to be more explicit.
Cetin
>Hi Cetin. Thanks for your reply.
>I had coded round the problem by appending into a Text field and doing a CTOD which worked.
>
>Funny, I just tried again appending to a Date field and it seems to have worjked ok, even with 13 in day field ..dont know why.
>
>I normally have set date british.. is there a difference with set date to dmy ?
>
>Regards,
>Gerard
>
>
>>>Hi.
>>>I am using Append from Myfile.tx type csv and one of the fields is a date field
>>> in format dd/mm/yyyy e.g. 31/12/2008
>>>I have Set date british but any dates with a day greater than 12, its importing incorrectly,
>>> as if its set to US date format
>>>
>>>Is there any way to import British dates from CSV file ?
>>>
>>>Regards,
>>>Gerard
>>
>>
>>set date to dmy
>>append from mycsv.csv type delimited
>>
>>Cetin