如图,这样是可以把日期传进去,但是现在要取上月我这块要怎么写才行,试了几次都不行。试了几种都不行
replace(DATE_ADD('" + datadate+"' ,INTERVAL -1 MONTH),"-","")
'" replace(DATE_ADD(+ datadate +,INTERVAL -1 MONTH),"-","")"'
'replace(DATE_ADD(" + datadate+",INTERVAL -1 MONTH),"-","")'
直接datedate改成
monthdelta(datedate,-1)
就可以了