Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date problem with APPEND FROM csv file
Message
De
08/09/2016 19:37:51
 
 
À
08/09/2016 02:49:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01640585
Message ID:
01640627
Vues:
66
>do it the hard way: define the field where the date in csv is as text and parse yourself... typical stage table approach for kinks found in process.
>
>>I'm developing have a little utility that imports data from .CSV files. I have problems with some dates. I have set:
>>
>>SET DATE BRITISH
>>SET CENTURY ON
>>
>>Dates come in british form (dd/mm/yyyy), they are NOT enclosed in quotation marks, they arrive to date type fields. After the APPEND FROM these dates suffer changes:
>>
>>CSV => VFP Cursor
>>16/05/1968 => 16/05/2019
>>19/06/2011 => 19/06/2020
>>02/04/1973 => 04/02/1973
>>11/08/2015 => 08/11/2015
>>04/05/1938 => 05/04/1938
>>26/07/2016 => 26/07/2020
>>22/05/2004 => 22/05/2020
>>24/03/2015 => 24/03/2020
>>13/09/1980 => 13/09/2019
>>16/05/1963 => 16/05/2019
>>
>>I tried changing to SET DATE AMERICAN and it becomes worst, the dates which previously are converted to end in 2020 appears blank.
>>
>>Does anyone have an idea?
>>
>>TIA

Yes, that's what I already did. I did not have much time to find out the cause of this strange thing. But I'm still curious.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform