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.
Userlevel 7
+17
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 &invoicetoHi 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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.