Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date problem with APPEND FROM csv file
Message
From
07/09/2016 17:12:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Date problem with APPEND FROM csv file
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01640585
Message ID:
01640585
Views:
80
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
Next
Reply
Map
View

Click here to load this message in the networking platform