search for: 2015_16

Displaying 3 results from an estimated 3 matches for "2015_16".

Case statement in sqldf
2017 Sep 11
4
Case statement in sqldf
...then '2013_14' + when ReportDate between '2014-04-01' and '2015-03-31' + 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...
Case statement in sqldf
2017 Sep 11
0
Case statement in sqldf
...9; > + when ReportDate between '2014-04-01' and '2015-03-31' > + 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 ...
Case statement in sqldf
2017 Sep 11
0
Case statement in sqldf
...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' when ReportDate between '2017-04-01' and '2018-03-31' then '2017_18' else null...