Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wrong Years
Message
De
22/07/2008 13:39:58
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
22/07/2008 13:33:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Divers
Thread ID:
01333160
Message ID:
01333231
Vues:
9
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform