I am unsure how to sort a column by date if it is currently in the form: YYYYMMDD For example the months: 20071031 20071130 20071231 Etc. Regards, Leigh [[alternative HTML version deleted]]
> a <- c( 20071031,20071130, 20071231)b<- sort(as.Date(as.character(a), format="%Y%M%d")) On Aug 2, 2010, at 8:03 PM, Leigh E. Lommen wrote:> I am unsure how to sort a column by date if it is currently in the > form: > > YYYYMMDD > > > > For example the months: > > 20071031 > > 20071130 > > 20071231 > > Etc. > > > > Regards, > > Leigh > > > [[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.
a <- c( 20071031,20071130, 20071231) sort(a) Or if you want convert to date: sort(strptime(a, '%Y%m%d')) On Mon, Aug 2, 2010 at 9:03 PM, Leigh E. Lommen < leigh.lommen@courtesycorporation.com> wrote:> I am unsure how to sort a column by date if it is currently in the form: > > YYYYMMDD > > > > For example the months: > > 20071031 > > 20071130 > > 20071231 > > Etc. > > > > Regards, > > Leigh > > > [[alternative HTML version deleted]] > > ______________________________________________ > 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. >-- Henrique Dallazuanna Curitiba-Paraná-Brasil 25° 25' 40" S 49° 16' 22" O [[alternative HTML version deleted]]