Hi Tjun Kiat,
This seems to work:
daily_date<-as.Date(paste("2000-01",1:28,sep="-"),"%Y-%m-%d")
weekly_date<-as.Date(paste(c(1,8,15,22,28),"01/2000",sep="/"),
"%d/%m/%Y")
cut(daily_date,breaks=weekly_date,include.lowest=TRUE,
labels=paste("Week",1:4))
Jim
On Fri, Jun 3, 2016 at 6:00 PM, TJUN KIAT TEO <teotj...@hotmail.com> wrote:
> I have two set of dates
>
> 2000-01-01
>
> 01/01/2000
>
> The second one occurs weekly and the first one occurs in daily. I would like
> to bin the first set of dates into the second set of dates. What is the best
> way to do it?
>
> I tried converting both formats into numeric formats
>
> DateBase=sort(as.numeric(as.POSIXlt(unique(Shipment$DateRequire),format="%Y-%m-%D",origin="1900-01-01")))
>
> Compare=as.numeric(as.POSIXlt(SMA$TIME_DATE,format="%d/%m/%y",origin="01/01/1900"))
>
> But the numeric numbers turned out to be very different.
>
> Tjun Kiat
>
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
______________________________________________
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.
