Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wrong Years
Message
From
22/07/2008 13:39:58
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01333160
Message ID:
01333231
Views:
10
>The rollover only applies to ambiguous dates (dates without a century). The data looks like 6/15/1999. This is a known bug in the VFP 9.0 bug list that was supposedly corrected with SP2. Such is not the case with us. If we save the file as an Excel workbook, the append works fine. It's only a problem with CSV files.

Forgot that one because I always export CSV, don't need to import... but, just a thought: can't you import into a cursor which would have a c(10) field for dates and an extra field for each date? So when you append all these date fields come in as they are, and then you just
replace all dDateField with ctod(cDateField)  ;
  , dDateField2 with ctod(cDatefield2)...
and append into your target table from the cursor.

>>>CSV. But when I open the csv file with Excel, that's the format the date fields are in.
>>
>>So Excel recognizes these strings as dates, and interprets (and displays) them so. What's the actual content of your csv file, what are your set("century"), rollover settings?

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform