Report Tasks within this week

Duraid

Hello. How to I create a report to pull tasks for this week, or next week dynamically without having to change the dates in the filter?

dojones

The easiest method is to use the Filter option in the report, "Is in the next", and put the number of days, 7 for example, to capture tasks that are coming due in the next 7 days.

If you need it to be this week or next week, create helper columns to identify when this week and next week ends and then compare the task date to those dates.

dojones

The easiest method is to use the Filter option in the report, "Is in the next", and put the number of days, 7 for example, to capture tasks that are coming due in the next 7 days.

If you need it to be this week or next week, create helper columns to identify when this week and next week ends and then compare the task date to those dates.

Duraid

I think help columns would do the trick. I wonder if there is a function i can use to return the week of the year

dojones

Use:

WEEKNUMBER([Your Date]@row)