Skip to main content
Question

Create Dropdown Filter for PO creation by Fiscal Year

  • August 20, 2019
  • 3 replies
  • 7 views
.
Level 1

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

3 replies

B
Level 0
  • benedict.lang
  • Level 0
  • 54 replies
  • August 20, 2019

Hey pdehn,

The function BETWEEN is what kills your CASE WHEN statement here. You could just do a

CASE WHEN

EKKO.AEDAT > {d 2018-04-30} AND EKKO.AEDAT < {d 2019-05-01} THEN 2019

ELSE

END

This should do the job for you. The additional brackets {d } convert the following string to a d = date. I chose < instead of <= just for personal preferences, I like it more this way.

Best Regards,

Benedict

.
Level 1
  • .14600778
  • Author
  • Level 1
  • 4 replies
  • August 20, 2019
Hello Benedict, that solved the problem. Thank you very much. Best Regards, Philipp
B
Level 0
  • benedict.lang
  • Level 0
  • 54 replies
  • August 20, 2019

Hey Philipp,

Glad to help! I realized that probably BETWEEN would have worked with the correct date statement ({d 2018-04-30}) rather than just the string, I didnt test it though.

Best Regards,

Benedict


Community Code of ConductAccessibility statement