[R] question about formatting Dates

arun smartpink111 at yahoo.com
Wed Jun 27 13:14:39 CEST 2012


Hi,

I can see the mistake in the code as "$" before Y.  

 dat1<-as.factor(c("1/2/2011","1/4/2011","1/4/2011"))


dat1
[1] 1/2/2011 1/4/2011 1/4/2011
Levels: 1/2/2011 1/4/2011
 as.Date(as.character(dat1), "%m/%d/%Y")
[1] "2011-01-02" "2011-01-04" "2011-01-04"
> as.Date(as.character(dat1),"%m/%d/$Y")
[1] NA NA NA

A.K.



----- Original Message -----
From: Erin Hodgess <erinm.hodgess at gmail.com>
To: R help <r-help at stat.math.ethz.ch>
Cc: 
Sent: Tuesday, June 26, 2012 11:54 PM
Subject: [R]  question about formatting Dates

Dear R People:

I have dates as factors in the following:

> poudel.df$DATE
[1] 1/2/2011  1/4/2011  1/4/2011  1/4/2011  1/6/2011  1/7/2011  1/8/2011
[8] 1/9/2011  1/10/2011
Levels: 1/10/2011 1/2/2011 1/4/2011 1/6/2011 1/7/2011 1/8/2011 1/9/2011
>

I want them to be "regular" dates which can be sorted, etc.

But when I did this:

> as.character(poudel.df$DATE)
[1] "1/2/2011"  "1/4/2011"  "1/4/2011"  "1/4/2011"  "1/6/2011"  "1/7/2011"
[7] "1/8/2011"  "1/9/2011"  "1/10/2011"

and
> as.Date(as.character(poudel.df$DATE),"%m/%d/$Y")
[1] NA NA NA NA NA NA NA NA NA

because the dates do not have leading zeros.

There are approximately 30 years of nearly daily data in the entire set.

Any suggestions would be much appreciated.

Sincerely,
Erin


-- 
Erin Hodgess
Associate Professor
Department of Computer and Mathematical Sciences
University of Houston - Downtown
mailto: erinm.hodgess at gmail.com

______________________________________________
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.




More information about the R-help mailing list