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.