In Quick Report, how can I use calendar Date picker on invoice date. Sample : SELECT *FROM IFSAPP.INVOICE WHERE INVOICE_DATE >= 'STAR OF YEAR' AND INVOICE_DATE <= 'END OF YEAR'
If I use SELECT *FROM IFSAPP.INVOICE WHERE INVOICE_DATE >= ‘&NVOICE_DATE’ then I have to type in date manually. Thank you in advance.
Best answer by Furkan Zengin
View original
+17
I tried it,but it still does not show as a calendar.
select objstate, order_no, planned_delivery_date where planned_delivery_date >= '&planned_delivery_date’ and planned_delivery_date <= '&planned_delivery_date’
+19
Hello
Query flags are not available in IFS cloud yet. Therefore you will not get a date picker for a quick report. Please review the documentation here.
KNOWN LIMITATION
Please note that due to an implementation constraint, use of query flags and enabling default values for parameters in SQL type Quick Reports is currently unavailable. Even though you could create a Quick Report with query flags and enable default values, it will not be affected when the Quick Report parameter page is shown. Currently there is no workaround solution.
Thank you very much Furkan
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
