周的横排序,变成月和日怎么弄,5.1-5.9,5.10-5.16这种的
RANGE(DATEDELTA(dateInWeek($qs, 1), -(WEEK(dateInWeek($qs, 1)) - $rq+1) * 7), DATEDELTA(dateInWeek($qs, -1), -(WEEK(dateInWeek($qs, 1)) - $rq+1) * 7))
分类字段准备一个「数据字典」,直接在绑定数据源时,形态转换一下即可!
——————————
自己拼接吧,参考
10是第十周 你可以替换成变量
dateInWeek(DATEDELTA(TODAY(),-(WEEK(TODAY())-10)*7),-1) 最后一天
dateInWeek(DATEDELTA(TODAY(),-(WEEK(TODAY())-10)*7),1) 第一天