Task Report Filter + 30 days

[NickVa1]

Hi WF Community,

Does anyone know if I can do the following filter on a task report?

• Task planned completion date = $$TODAY+30d

I'd like to filter tasks that have a planned completion date within the next 30 days. I'd like to avoid a static filter that uses the 'between' operator, as I would have to update that filter everyday in order for it to capture the next 30 days.

My above filter doesn't seem to capture any results (aka not working).

Thoughts?

Thanks.

Nick

[AdinaPi1 · Accepted solution]

You're close.

Do Task > Planned Completion Date Between $$NOW (or $$TODAY) and $$TODAY+30d

[NickVa1]

Ahhh, 'between', that's it! You rock, thanks, Adina!