[Ham-Computers] Microsoft Excel 2000 Date Related Question

[WA5CAB at cs.com]

Group,

For reasons I won't waste time going into we have to file a Texas Sales Tax 
report quarterly.  Years ago, I wrote a dBase application to do the report. 
 Some of the data is in an .XLS file which I convert to .CSV and then 
import into a .DBF file.  Dates in the .XLS file are formatted YYYY-MM-DD (with 
leading zeroes where needed in Month and Date).  When I did the 1st Quarter 
report in April, the format remained the same in the .CSV and thus in the 
.DBF, as it has for several years.  When I started doing the 2nd Quarter 
report, I got errors and strange results and discovered that although the date 
format is still the same in the .XLS, in the .CSV it becomes M/D/YYYY where M 
and D are either one or two digits depending.  AFAIK, nothing has changed 
since April except the usual rash of MS OS "security fixes".  If anyone has a 
clue as to what might have happened or how to fix it, please let me know.

Robert Downs - Houston
wa5cab dot com (Web Store)
MVPA 9480