Dynamic Dates

Linn Cook

I am creating task reports for our team that pulls tasks from multiple sheets and aggregates them into one, easy to read report. I'm using reports because I want to apply date filters and structure task reports to show all outstanding tasks (past due and due today) and upcoming tasks (tasks due within the next week).

 

I thought I created a report to do this, but the date filter turned out to be static and need to be updated daily in order to function properly. Am I doing something wrong is there not a way to set the date filter to change dynamically? 

Richard Rymill SBP

Hi Linn

In reports you have the date choices of ... In the past, or Today  or in the next xxxxx? 

So you should be able to get just what you need? 

 

Let us know if not and we can review the issue together? 

 

Regards 

RichardR 

Linn Cook

Ah I see the problem. When I selected the date range, I used "Is less than" and then selected "Today" from the calendar. My bad. Thank you for clarifying that for me.