YYYYMMDD will work. Just tried it.


>OIC....Let me experiment with a workaround and I'll reply back to this message shortly.
>
>
>>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