if(day(today())< 10,DATEINMONTH(MONTHDELTA(today(),-1),1),today())
if(day(today())< 10,DATEINMONTH(MONTHDELTA(today(),-1),-1),today())
---
当前日期小于10,取上月第一天最后一天,否则取当日
--------
sql("数据连接","select 字段 from 表 ",1,1)
取出来最大日期,然后判断
if(day(today())>10,DATEINMONTH(today(),1),DATEINMONTH(MONTHDELTA(today(),-1),1))
DATEINMONTH(today(),1) 本月第一天
DATEINMONTH(MONTHDELTA(today(),-1),1) 上月第一天
DATEINMONTH(MONTHDELTA(today(),-1),-1)上月最后一天