Displaying 2 results from an estimated 2 matches for "2014_15".
Did you mean:
201415
2017 Sep 11
0
Case statement in sqldf
...then '2012_13'
when ReportDate between '2013-04-01' and '2014-03-31'
then '2013_14'
when ReportDate between '2014-04-01' and '2015-03-31'
then '2014_15'
when ReportDate between '2015-04-01' and '2016-03-31'
then '2015_16'
when ReportDate between '2016-04-01' and '2017-03-31'
then '2016_17'...
2017 Sep 11
4
Case statement in sqldf
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.
library(zoo)
library(lubridate)
library(stringr)
library(RH2)
library(sqldf)
cr$ReportDate = as.Date(cr$ReportDate, format ='%Y-%m-%d')
> cr2 = sqldf(" select