Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Last 5 days rolling

Dear all,

I have created a report which calculates the averages for Month to date, year to date, last full working days week and last 4 working days week.

Now I would like to add another feature which is going to show me the records of last 5 rolling days, meaning if today is 11/09/2008, the report should get the data from 10/09/2008 to 04/09/2008 (6,7 skipped because of weekends).

I have tried using the formula like this

{lab_rework.rework_date} in ((date(year(currentdate),month(currentdate),day(Currentdate)-5))) 
to
((date(year(currentdate),month(currentdate),day(Currentdate)-1)));

but this didn't work.

I then looked up on the help file and found out Last7Days however I am not sure how to use it to make it work with last 5 working days.

I am trying like this but this isn't working

{lab_rework.rework_date} in ((date(year(currentdate),month(currentdate),last7days-2)))

Any ideas?

Regards

Jehanzeb

Not what you were looking for? View more on this topic or Ask a question