Task Report Filter + 30 days | Community
Skip to main content
Level 9
Jun 5, 2020 8:01 PM UTC
Solved

Task Report Filter + 30 days

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
AdinaPi1Accepted solution
Level 9
Jun 5, 2020 8:06 PM UTC

You're close.

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

2 replies

NickVa7Author
Level 9
Jun 5, 2020 8:10 PM UTC

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

Translate
AdinaPi1Accepted solution
Level 9
Jun 5, 2020 8:06 PM UTC

You're close.

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

Translate