Report Filter by date

hiker360

I need to create a report for past due items. As such, I need to compare a due date to the current date. How do I do this in a report? I don't want to set the date to today every time as I want an automated report. I tried putting in the compare date to the sheet I am reporting off of but there is no option to compare two date columns, the filter requires a set date.

Hollie Green

I would recommend adding a past due column on the sheet you are referencing and use a formula to mark it as past due. Include that in your report and you can filter to Past due.