Displaying 3 results from an estimated 3 matches for "2012_13".
2017 Sep 11
4
Case statement in sqldf
...y(RH2)
library(sqldf)
cr$ReportDate = as.Date(cr$ReportDate, format ='%Y-%m-%d')
> cr2 = sqldf(" select ReportDate
+ , case
+ when ReportDate between '2012-04-01' and '2013-03-31'
+ 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'201415'
+...
2017 Sep 11
0
Case statement in sqldf
...cr$ReportDate = as.Date(cr$ReportDate, format ='%Y-%m-%d')
>
>> cr2 = sqldf(" select ReportDate
> + , case
> + when ReportDate between '2012-04-01' and '2013-03-31'
> + 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...
2017 Sep 11
0
Case statement in sqldf
...library(sqldf)
library(RH2)
cr <- data.frame(ReportDate = as.Date("2017-09-11")) # input
cr2 = sqldf(" select ReportDate
, case
when ReportDate between '2012-04-01' and '2013-03-31'
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'...