Quick report - missing right parenthesis error Hi, The following code works in the database when run. select COH.DATE_ENTERED, COH.ORDER_NO, COH.ORDER_ID, COH.CONTRACT, COH.CUSTOMER_NO, COH.CUST_REF, COH.C_DEPOT, COH.STATE, COA.addr_1, COA.addr_2, COA.addr_3, COA.addr_4, COA.addr_5, COA.addr_6, COA.address1, COA.address2, COA.address3, COA.address4, COA.address5, COA.address6, COA.zip_code, COA.city, COA.state, COA.county from ifsapp.CUSTOMER_ORDER COH left join ifsapp.CUST_ORD_ADDRESS_2_UIV COAon COA.order_no = COH.ORDER_NOwhere to_date(COH.DATE_ENTERED,'dd/mm/yy') between to_date('&DATE_FROM', 'dd/mm/yy') and to_date('&DATE_TO', 'dd/mm/yy') and COH.ORDER_NO like 'H%'and COH.CONTRACT like '%' || upper('&SITE') || '%' However, when running the code in a quick report. I receive the following error: