Re: [R] Difference in numeric Dates between Excel and R

2011-03-02 Thread Prof Brian Ripley
On Wed, 2 Mar 2011, Erich Neuwirth wrote: A detailed description of the Excel problem as seen through the eyes of MS can be found at http://support.microsoft.com/kb/214326 No, that's only half the problem. The description at http://support.microsoft.com/kb/214330 (as cited in the as.Date.R

Re: [R] Difference in numeric Dates between Excel and R

2011-03-02 Thread Erich Neuwirth
A detailed description of the Excel problem as seen through the eyes of MS can be found at http://support.microsoft.com/kb/214326 On 3/2/2011 8:15 AM, Prof Brian Ripley wrote: > > ## Excel is said to use 1900-01-01 as day 1 (Windows default) or > ## 1904-01-01 as day 0 (Mac default), b

Re: [R] Difference in numeric Dates between Excel and R

2011-03-01 Thread Prof Brian Ripley
On Wed, 2 Mar 2011, Luis Felipe Parra wrote: Hello. I am using some dates I read in excel in R. I know the excel origin is supposed to be 1900-1-1. But when I used as.Date with origin=1900-1-1 the dates that R reported me where two days ahead than the ones I read from Excel. I noticed that when

Re: [R] Difference in numeric Dates between Excel and R

2011-03-01 Thread David Scott
On 2/03/2011 12:31 p.m., Nordlund, Dan (DSHS/RDA) wrote: -Original Message- From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- project.org] On Behalf Of Luis Felipe Parra Sent: Tuesday, March 01, 2011 3:07 PM To: r-help Subject: [R] Difference in numeric Dates between Excel and

Re: [R] Difference in numeric Dates between Excel and R

2011-03-01 Thread Nordlund, Dan (DSHS/RDA)
> -Original Message- > From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- > project.org] On Behalf Of Luis Felipe Parra > Sent: Tuesday, March 01, 2011 3:07 PM > To: r-help > Subject: [R] Difference in numeric Dates between Excel and R > > Hello. I am us

[R] Difference in numeric Dates between Excel and R

2011-03-01 Thread Luis Felipe Parra
Hello. I am using some dates I read in excel in R. I know the excel origin is supposed to be 1900-1-1. But when I used as.Date with origin=1900-1-1 the dates that R reported me where two days ahead than the ones I read from Excel. I noticed that when I did in R the following: > as.Date("2011-3-4")