[R] Date format issue.

jim holtman jholtman at gmail.com
Tue Jun 28 14:27:47 CEST 2011


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 <ashimkapoor at gmail.com> 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. 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 me where I am wrong in this date format conversion
> ?
>
> Thank you all very much.
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>



-- 
Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?



More information about the R-help mailing list