[Ham-Computers] Microsoft Excel 2000 Date Related Question

[Mike]

Robert -

Take a look at this web page and see if it addresses your issue. 
http://support.microsoft.com/kb/307938

Scroll down to "To Change the Date Display".

73, Mike NF4L

On 7/16/2011 1:09 PM, WA5CAB at cs.com wrote:
> 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
> ______________________________________________________________
> Ham-Computers mailing list
> Home: http://mailman.qth.net/mailman/listinfo/ham-computers
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:Ham-Computers at mailman.qth.net
>
> List Administrator: Duane Fischer, W8DBF
> ** For Assistance: dfischer at usol.com **
>
>
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html
>