Filter records if more then 7 days.

[Former Member]

Does anyone know how I can filter my records if more then 7 days.

Basically I want to create a task report and then report on all task due for the week. Is there a formula i can use to suppress if task due date is past the week?

[abhilash_kumar · Accepted solution]

Hi Jared,

Go to report > selection formulas > record and use this code:

{task_due_date} <= Minimum(WeekToDateFromSun) + 6

-Abhilash

[Former Member · Accepted solution]

Awesome! Thanks