Skip to main content

Hallo,

 

I am trying to create a predefined view filter to filter POs starting from 01.01.2023 until today, so that users when opening the view get all the data regarding POs from 01.01.2023 until the date they open the view.

 

This is how i did it but it is not working i guess because it sees the date format as String.

 

Any Idea of how can i solve this, will be appreciated!

 

FILTER "EKKO"."AEDAT" BETWEEN '2023-01-01' AND TODAY();

 

Thank you!

Hello, I don't think AEDAT date can be in the future so you can actually just omit that part of the script.

Also, the date constant needs to be in this format: {d '2023-01-01'}

So the filter should look like: FILTER "EKKO"."AEDAT" >= {d '2023-01-01'};


Reply