Re: [R] Case statement in sqldf

2017-09-12 Thread Mangalani Peter Makananisa
Thank you very much, I will work on it -Original Message- From: Gabor Grothendieck [mailto:ggrothendi...@gmail.com] Sent: 11 September 2017 06:50 PM To: Mangalani Peter Makananisa Cc: r-help@r-project.org Subject: Re: Case statement in sqldf 2018-03-3 in your code should be 2018-03-31.

Re: [R] Case statement in sqldf

2017-09-12 Thread Mangalani Peter Makananisa
Thanks D, I will work on the solution you gave and give feedback. -Original Message- From: David Winsemius [mailto:dwinsem...@comcast.net] Sent: 11 September 2017 05:19 PM To: Mangalani Peter Makananisa Cc: r-help@r-project.org Subject: Re: [R] Case statement in sqldf > On Sep

Re: [R] Case statement in sqldf

2017-09-11 Thread Gabor Grothendieck
2018-03-3 in your code should be 2018-03-31. The line then'201415' needs to be fixed. When posting please provide minimal self-contained examples. There was no input provided and library statements not relevant to the posted code were included. Fixing the invalid date and bad line, getting r

Re: [R] Case statement in sqldf

2017-09-11 Thread David Winsemius
> On Sep 11, 2017, at 1:05 AM, Mangalani Peter Makananisa > wrote: > > Hi all, > > I am trying to create a new variable called Fiscal Year (FY) using case > expression in sqldf and I am getting a null FY , see the code below . > > Please advise me as to how I can do this mutation. > > li