Let me give you an example of the problem I am having.

01/01/2000 imports as {01/01/0020}

01012000 imports as {01/01/1900}

010100 imports as {01/01/1900}

01/01/00 imports as {01/01/1900}

Thanks, Chris

Yes, VFP will pull in *any* dates if formatted MM/DD/YYYY.


>It can be what ever I choose. That is part of my question. How do I need to farmat it? Is it possible in 6.0 to pull in 2000 dates?
>
>What I hac done historically is append into a character field then convert that to a date.
>
>However, the file are quite large and I am looking for a better way.
>
>
>>What is the incoming format of the text?
>
>> >Yes, but I need the century to say 2000.
>> >
>> >Thanks, Chris