Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
APPEND FROM and dates
Message
From
09/09/2004 09:47:39
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
09/09/2004 09:45:05
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00940584
Message ID:
00940609
Views:
19
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