日期控件的格式对么?
----------
试试
select * from DA_OFFICE_SUPPLIES
WHERE
'FBizDate' BETWEEN '${FORMAT(starttime,"yyyy-MM-dd")}' AND '${FORMAT(endtime,"yyyy-MM-dd")}'
--------
还有这两个日期不能传空值,允许空
select * from DA_OFFICE_SUPPLIES
WHERE 1=1 ${if(len(starttime)=0,""," and FBizDate>='"+FORMAT(starttime,"yyyy-MM-dd")+"'")}${if(len(endtime)=0,""," and FBizDate<='"+FORMAT(endtime,"yyyy-MM-dd")+"'")}