Hi Guys, I've found an anomaly which may be a bug.
To replicate the problem create a text file of date in British (dd/mm/yy) format such as the one below: DoB 1/4/1987 7/4/1986 14/4/1985 21/4/1987 28/4/1986 Then use the code below to append to a table: SET DATE BRITISH CREATE TABLE Birthdays (Dob D) APPEND FROM testdata.txt TYPE delimited The dates are imported as expected, the first line is blank which is what I would expect. Now replace the third line with: APPEND FROM testdata.txt TYPE CSV The first 2 dates are OK but the rest where dd > 12 shows with the day and the month correct but the year as 0198!!! Replace SET DATE BRITISH with SET DATE AMERICAN and it works as expected with the last 3 dates being blank. I've implemented a workaround but would be interested in any comments. John Weller Wessex Computer Solutions 01380 728880 07976 393631 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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.
