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
