Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date problem with APPEND FROM csv file
Message
From
08/09/2016 02:49:41
Thomas Ganss (Online)
Main Trend
Frankfurt, Germany
 
 
To
07/09/2016 17:12:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01640585
Message ID:
01640601
Views:
186
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform