Please see my attached files. I want to be able to filter >= &invoicefrom from my report. Settlement Period From is invoice date. Sample, 05.02.2024 from db format is date, month, year from value list. In Filter Criteria, when I set invoice =& invoicefrom (like 05.02.2024) is returns data as expected. However, if I set to >=&invoicefrom (like 05.02.2024) it returns the whole data, which I don’t need. How can this issue be corrected? Eventually, I want to set my report like invoice >=& invoicefrom and invoice <=& invoiceto. Thank you in advance.
IFS Business reporter - invoice date range
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/5c1b0620-7a3c-44db-a823-6a4705a8c820.png)
Additionally I think you could use the Advanced tab and write the below filter condition which should also do the trick.
invoice between &invoicefrom and &invoiceto
Hi Marcel, This is Germany date. Do I need to convert date? How can this be in Advanced tab? Please see my image. I want to pass values from user input (parameters) like invoiceFrom and invoiceTo
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/cf0d76ff-aa19-4dfc-a44b-4f8a8e935611.png)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.