General information
Category:
Coding, syntax & commands
I must have tried every other format. Thanks a bunch!
Chris
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only