Displaying 3 results from an estimated 3 matches for "2016_17".
Did you mean:
20160107
2017 Sep 11
4
Case statement in sqldf
...then'201415'
+ 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'
+ when ReportDate between '2017-04-01' and '2018-03-3'
+ then '2017_18' else null
+ end as FY
+ from cr
+ where ReportDate >= '2012-04-01'
+ &quo...
2017 Sep 11
0
Case statement in sqldf
...9;
> + 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'
> + when ReportDate between '2017-04-01' and '2018-03-3'
> + then '2017_18' else null
> + end as FY
> + from cr
> + where ReportDate >= '2012-04-01...
2017 Sep 11
0
Case statement in sqldf
...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'
when ReportDate between '2017-04-01' and '2018-03-31'
then '2017_18' else null
end as FY
from cr
where ReportDate >= '2012-04-01'
")
giving:
> cr...