Re: [R] Date format issue.

2011-06-28 Thread David Winsemius
On Jun 28, 2011, at 8:04 AM, Ashim Kapoor wrote: Dear R helpers, I have 2 questions : - 1. My excel sheet has a column with dates like 01/03/1980 which is formatted as 03/80 when I read this into R it reads as Mar-80. You should be able to change that from the format menu in Excel. If

Re: [R] Date format issue.

2011-06-28 Thread Ashim Kapoor
You get the NA since it is indeterminate as to the date; paste on a 1 > for the day" > Alright Jim, Many thanks. [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE d

Re: [R] Date format issue.

2011-06-28 Thread jim holtman
You get the NA since it is indeterminate as to the date; paste on a 1 for the day" > v<-c("Mar-80") > as.Date(paste(v, '1'),format="%b-%y %d") [1] "1980-03-01" On Tue, Jun 28, 2011 at 8:04 AM, Ashim Kapoor wrote: > Dear R helpers, > > I have 2 questions : - > > 1. My excel sheet has a column wi

[R] Date format issue.

2011-06-28 Thread Ashim Kapoor
Dear R helpers, I have 2 questions : - 1. My excel sheet has a column with dates like 01/03/1980 which is formatted as 03/80 when I read this into R it reads as Mar-80. How can I read it in the source format ? 2. > v<-c("Mar-80") > as.Date(v,format="%b-%y") [1] NA > Could someone please tell m