Oops, this didn't get to the list, due ro a 'senior moment' by me.
-----Original Message-----
From: mica [mailto:statman1957@hotmail.com]
Sent: 20 January 2005 15:44
Cc: 'jsv@stat.ohio-state.edu'
Subject: RE: [S] Y1.9K ?
Welcome to the world of Excel, which begins in 1900. Excel's internal
representation of The date format is AFAIK as a (positive) offset from Jan
1st 1900 at 0:00hrs. If you need dates in Excel (97 or later) prior to this,
there is an add-in - check here:
http://www.j-walk.com/ss/excel/usertips/tip028.htm
Regards
Mike
-----Original Message-----
From: s-news-owner@lists.biostat.wustl.edu
[mailto:s-news-owner@lists.biostat.wustl.edu] On Behalf Of
jsv@stat.ohio-state.edu
Sent: 20 January 2005 00:44
To: s-news@lists.biostat.wustl.edu
Subject: [S] Y1.9K ?
As I was importing an Excel file (version apparently not important into
Splus (version 6.2.1 for Windows), an odd thing happened. One of the "date"
columns (date of birth) was being read as a factor variable rather than a
timeDate variable.
Upon further examination, I noticed that two of the dates were pre 1900.
When I changed these to post 1900, the data read in correctly as timeDate
(which I could easily edit back to the correct dates). The format in the
Excel file was "mm/dd/yyyy". Any explanation for this behavior?
--------------------------------------------------------------------
This message was distributed by s-news@lists.biostat.wustl.edu. To
unsubscribe send e-mail to s-news-request@lists.biostat.wustl.edu with the
BODY of the message: unsubscribe s-news
|