Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
APPEND FROM and dates
Message
From
09/09/2004 11:19:38
 
 
To
09/09/2004 10:52:54
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00940584
Message ID:
00940668
Views:
19
Assuming there are more fields in the text file than just the date field, then I think Tore is right. To us, it looks like a date, but to SDF, it looks like a 10 wide character field. If it were the only field in the text file then you could tell it DELIMITED regardless of the fact that there are no delimiters.

Alan

>Hi Tore
>
>>I don't think you can avoid it.
>
>Well, this is the place to find out for certain. ;)
>
>Thanks!
>>
>>>Hi Tore
>>>
>>>That's the workaround I already have in place. I'm hoping to avoid that.
>>>
>>>>Hi Mike,
>>>>
>>>>1. create a cursor with the correct structure, but have a dummy character field in stead of a date field, and add a date field with the correct name at the end.
>>>>2. Import from your textfield
>>>>3. replace all datefield with ctod(yourdummyfield)
>>>>4. import from the cursor
>>>>
>>>>
>>>>>Hi Beth
>>>>>
>>>>>Yep. Tried that. Didn't work.
>>>>>
>>>>>Thanks!
>>>>>>Hi, Mike,
>>>>>> Do you have set century on?
>>>>>>>Hi all
>>>>>>>
>>>>>>>Given a text file with 11/12/1987 and a dbf with a single date field, APPEND FROM results in 11/12/19 in the date field.
>>>>>>>
>>>>>>>What must I do to have APPEND FROM import that date correctly?
Previous
Reply
Map
View

Click here to load this message in the networking platform