Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date problem with APPEND FROM csv file
Message
De
07/09/2016 17:12:27
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Date problem with APPEND FROM csv file
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01640585
Message ID:
01640585
Vues:
81
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform