select * from uf_project_card where loan_amount>0 and project_status<>200 and FORMAT(loan_date,"yyyy-MM") =FORMAT(now(),"yyyy-MM")
select * from
uf_project_card
where
loan_amount>0
and project_status<>200
and loan_date>='${DATEINMONTH(today(),1)}'
and loan_date<='${DATEINMONTH(today(),-1)}'
----------------或者这样-------------------
and date_format(loan_date,'%Y-%m')='${format(today(),"yyyy-MM")}'
数据集中sql可以使用帆软公式
例如
select * from 表 where 年字段='${year(today())}'
=============
select * from uf_project_card
where loan_amount>0 and project_status<>200
and ${MONTH(loan_date) = MONTH(now())}
and ${YEAR(loan_date) = YEAR(today())}
FORMAT(today(),"yyyy-MM")
这个是当前年月，你想怎么判断
1min目标场景问卷
立即参与
