把Year ='${Year}', Mounth = '${Mounth}'刪掉是可通過的! 但加了這2行系統報錯,求解?
更新:加了and後
还有,你是自定义字段,需要用原来写法
and SUBSTRING(invoicedate ,1,4)='${Year}'
and SUBSTRING(invoicedate ,5,2)='${Mounth}'