日期脚本

怎么要在自有表表中纵向年，横向按照天数同时展示今年近七天，去年近七天

设置单元格过滤
绑定上下两个单元格，扩展成两行，分别设置单元格过滤 日期大于近七天的参数脚本参考
var now_date = new Date()
var a= dateAdd(now_date,'dayofyear',-7); //近七天
var b = dateAdd(a,'year',-1); //去年近七天

var edate = 下拉参数1.getSelectedObjects()[0]

var edate = 下拉参数1.getSelectedObjects()[0]
var sdate_1 = day(edate)
var sdate = dateAdd(edate,'dayofyear',-sdate_1+1)
param['sdate'] = sdate
var sdate_2 = dateAdd(edate,'dayofmonth',-sdate_1)
var edate_1 = dateAdd(edate,'month',-1)
var sdate_3 = day(edate_1)
var sdate_4 = dateAdd(edate_1,'dayofyear',-sdate_3+1)
var sdate_5 = dateAdd(edate,'year',-1)
var sdate_6 = dateAdd(edate,'dayofyear',-6)
var sdate_7= dateAdd(sdate_6,'year',-1)
param["sdate-1"] = sdate_4
param["da"] = sdate_2
param["前日"] = dateAdd(edate,'dayofyear',-1)
param["上月第一天"] =dateTrunc('month',dateAdd(edate,'month',-1));
param["上月同期"] = edate_1
param["上周"] = weeknum(edate,2)-5
param["月首"] = dateTrunc('month',edate)
param["近7天"]= sdate_6

我的近七天绑定的下拉参数，但是我那样设置有啥不对吗

还有就是日期要对上2023/2024年都要横向扩展

可以试试 日期参数组件https://plugins.yonghongtech.com/plugin/19