Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date problem with APPEND FROM csv file
Message
From
08/09/2016 19:37:51
 
 
To
08/09/2016 02:49:41
Thomas Ganss (Online)
Main Trend
Frankfurt, Germany
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:
01640627
Views:
65
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform