请问一下,在查询报表的日期范围时候用between and就报错;用>= 和<= 就成功这是为什么?
${if(len(dbill_date1)==0 && len(dbill_date2)==0 ,"","and dbill_date between '"+ dbill_date1 + " and " + dbill_date2 +"'")}
81705
${if(len(dbill_date1)==0,"","and dbill_date >='"+ dbill_date1 +"'")}
${if(len(dbill_date2)==0,"","and dbill_date <='"+ dbill_date2 +"'")}
81706