I have SET DATE BRITISH. I have just now found that this works:
CLOSE DATABASES ALL
SET CENTURY ON
SET SAFETY OFF
SET DATE BRITISH
CREATE CURSOR tmp (dated D)
INSERT INTO tmp VALUES ({^1999/10/23})
INSERT INTO tmp VALUES ({^2000/10/23})
INSERT INTO tmp VALUES ({^2001/10/23})
BROWSE NORMAL
SET DATE MDY
COPY TO tmp.csv TYPE CSV
MODIFY FILE tmp.csv NOEDIT
ZAP
APPEND FROM tmp.csv TYPE CSV
SET DATE BRITISH
BROWSE NORMAL
SET SAFETY ONIt seems that csv files want dates in AMERICAN or MDY format. Laurie On 15 April 2015 at 12:17, Tracy Pearson <[email protected]> wrote: > > > Laurie, > > What is your value of SET("DATE")? > > Tracy > > On April 15, 2015 5:08:16 AM EDT, Laurie Alvey <[email protected]> > wrote: > >That's weird. I've always had the problem with CSV imports from VFP 3. > >I'm > >running VFP 9 SP2 on XP Pro SP3. I'd love to know the solution to this. > >By > >the way, I once (about 2003) brought this to the attention of Andy > >Kramek > >who saw the same problem - what's different? > > > >Laurie > > > >On 14 April 2015 at 18:33, Gene Wirchenko <[email protected]> wrote: > > > >> At 03:20 2015-04-14, Laurie Alvey <[email protected]> wrote: > >> > >>> Another issue with CSV files is that dates get mangled. The > >following code > >>> illustrates this: > >>> > >> > >> I tried it. Both sets of dates were correct. > >> > >> [snip] > >> > >> Sincerely, > >> > >> Gene Wirchenko > >> > >> > -- > Sent from my Android device with K-9 Mail. Please excuse my brevity. > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/camvtr9eqijcy2bzn1aqvdycye7exjythj6jyvnofvibvxmk...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
