Hi, There are possibly several ways to do this. My approach would be:
dates <- strptime(as.character(DATE), "%d%b%Y") year <- dates$year + 1900 week <- floor(dates$yday/365 * 52) HTH, --sundar On Thu, Mar 5, 2009 at 8:58 AM, Pele <drdi...@yahoo.com> wrote: > > Hi R users, > > I have a factor variable called date as shown below: Can anyone share the > best / most efficient way to extract year and week (e.g. year = 2006, week > = 52 for first record, etc..)? My data set has 1 million records. > > DATE > 11DEC2006 > 11SEP2006 > 01APR2007 > 02DEC2007 > > > Thanks in advance for any help! > -- > View this message in context: > http://www.nabble.com/Date-conversion-tp22355788p22355788.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@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. > ______________________________________________ R-help@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.