General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only