Using Report builder to find past due 'Days' tasks

Rohit Rao

I have a sheet that lists bugs and it has a 'Created Date' column (not a system column, just a date column). I need to generate a report of all issues that are 'Open'  and 30 days old. I can check for 'Open'. But I wasn't able to find a way to check for 30 days old in the report builder. Can I do this just using the report builder without adding addtional columns to the sheet? Something like'todays date'-created date >30 under the 'When' criteria in Report Builder?

J. Craig Williams

This should be possible.

In the Report Builder, select the "When?" button to select the date column of interest.

Once selected, you can set the criteria. I assume you mean "older than 30 days"

so use three choices:

(in the last 30 days) or (today) or (in the future)

and then click the exclude checkbox.

 

And your check for ''Open" and Bob's your uncle.

 

Craig

Rohit Rao

Urgh! I had missed the all powerfull 'Exclude' check box. Thanks Craig!!

 

J. Craig Williams

Definitely worth while.

There's a few complex conditions that won't work in the Report Builder, but many can be.

 

Craig