Re: [R] Sldf command returns negative value for date

2014-08-15 Thread Sneha Bishnoi
It works :) Thanks so much! I tried searching a lot but I guess i missed this fact! On Thu, Aug 14, 2014 at 4:35 PM, Gabor Grothendieck wrote: > On Thu, Aug 14, 2014 at 3:47 PM, Sneha Bishnoi > wrote: > > Hi All! > > > > I am trying to increment date column of data frame so as to merge it with

Re: [R] Sldf command returns negative value for date

2014-08-14 Thread Gabor Grothendieck
On Thu, Aug 14, 2014 at 3:47 PM, Sneha Bishnoi wrote: > Hi All! > > I am trying to increment date column of data frame so as to merge it with > another data frame using sqldf: > my query is : > merge<-sqldf("select m.* ,e.* from mdata as m left join event as e on > date(m.Datest,'+1 day')=e.Start"

[R] Sldf command returns negative value for date

2014-08-14 Thread Sneha Bishnoi
Hi All! I am trying to increment date column of data frame so as to merge it with another data frame using sqldf: my query is : merge<-sqldf("select m.* ,e.* from mdata as m left join event as e on date(m.Datest,'+1 day')=e.Start") The query returns null for all columns related to event table. Wh