Hi ,
I have data something looks like below (or PFA), but when I’m extracting month using *strftime* function through *sqldf* library ,it’s returning below results but it’s not returning exact results ,it supposed to return 05,05,05,06,06,06.Can anyone please guide me how to do that with *strftime* function. Thanks in advance. Quiries : library(scales) # load data: log <- data.frame(Date = c("2013/05/25","2013/05/28","2013/05/31","2013/06/01","2013/06/02","2013/06/05","2013/06/07"), Quantity = c(9,1,15,4,5,17,18)) # convert date variable from factor to date format: log$Date <- as.Date(log$Date, "%Y/%m/%d") # tabulate all the options here str(log) Manu.
______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.