Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
APPEND FROM and dates
Message
From
09/09/2004 10:46:11
 
 
To
09/09/2004 09:47:39
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00940584
Message ID:
00940649
Views:
25
I don't think you can avoid it.

>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
Next
Reply
Map
View

Click here to load this message in the networking platform