Hi,
Try this:
Year<-c("01/2000","02/2000","03/2000")
#If you want to convert it directly to month/year
library(zoo)
as.yearmon(Year,format="%m/%Y")
[1] "Jan 2000" "Feb 2000" "Mar 2000"
#As your intention is to have DD/MM/YYYY format,
?Year1<-paste("01/",Year,sep="")
Year1
[1] "01/01/2000" "01/02/2000" "01/03/2000"
?Year<-as.Date(Year1, format="%m/%d/%Y")
?Year
[1] "2000-01-01" "2000-01-02" "2000-01-03"
dat1<-data.frame(Year1,Stock_Prices=1:3)
??????? Year Stock_Prices
1 2000-01-01??????????? 1
2 2000-01-02??????????? 2
3 2000-01-03??????????? 3
A.K.
----- Original Message -----
From: Akhil dua <akhil.dua.12 at gmail.com>
To: r-help at r-project.org
Cc:
Sent: Wednesday, July 4, 2012 12:13 AM
Subject: [R] Date
Hi
I have monthly data and the dates are in MM/YY Format
I need to convert them into DD/MM/YY format by pasting 01 in place of DD to
all the observations in my Year Column
ex:
Year? ? ? ? ? ? Stock Prices
01/2000? ? ? ? ? 1
02/2000? ? ? ? ? 2
03/2000? ? ? ? ? 3
I need to convert them to
Year? ? ? ? ? ? ? ? ? ? ? Stock Prices
01/01/2000? ? ? ? ? ? ? 1
01/02/2000? ? ? ? ? ? ? 2
01/03/2000? ? ? ? ? ? ? 3
??? [[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.