Hello,
we want to add two dropdown filters to select purchase order items by creation year.
One by calender year and one by fiscal year.
The one for calender year would just be YEAR(EKKO.AEDAT).
For the fiscal year the dropdown option 2019 should contain all purchase order items with EKKO.AEDAT between 1st of May 2018 and 30th of April 2019 and so on. Can this be implemented?
I tried the following, but the error not implemented yet appears.
CASE
WHEN EKKO.AEDAT BETWEEN 2018-05-01 AND 2019-04-30 THEN 2019
ELSE
END