关于按月取周问题

[aj1532]

delete from ll_temp;
commit;
ll_num = DaysAfter(date(rundate1),date(rundate2))//得到两个日期区间有多少天
iii=1
ll_date=rundate1
ll_num = ll_num + 1
for i=1 to ll_num step 1
if i>1 then
ll_date =relativedate(rundate1,i - 1)
end if
ii = DayNumber ( ll_date)
if ii = 7 then
iii=iii + 1
end if


select sum(sale_amount) into :ll_mon from wyt_1 where run_date=:ll_date;

insert into ll_temp(month,amnt,day) values (:ii,:ll_mon,:iii);
commit;
next


各位老大..谁知道为什么取出的数据第一周少两天...确加在最后一周里了...

[风_雨_晴]

每个星期第一天是星期天

[风_雨_晴]

for i = 0 to ll_num step 1
  ll_date =relativedate(rundate1,i)

这样不就不用+1，-1了吗

[张义雄]

路过