帆软推送近两周的数据,到周一只有一周怎么处理,因为周一的数据还没有生成,怎么写控件公式让周一时间范围是前两周的,周二是上周加本周
你这个是每天运行?周二就取上周一至本周星期天结束?
where 1=1
and 日期字段>='${if(WEEKDAY(today())=1,DATEDELTA(today(),-14),DATEDELTA(DATEINWEEK(TODAY(),1),-7))}'
and 日期字段<='${today()}'
结束时间获取到昨日
IF(TODAY()=DATEINWEEK(TODAY,1),CONCATENATE(DATEINWEEK(DATEDELTA(TODAY(),-14),1),"至",DATEINWEEK(DATEDELTA(TODAY(),-1),-1)),CONCATENATE(DATEINWEEK(DATEDELTA(TODAY(),-8),1),"至",TODAY()))