Reporting on Due Dates

[Ann]

Afternoon 

Hope you are all safe and well. 

Please would it be possible for some help/guidance with reporting?  I was wondering if there is a way to report on expired tasks please, for example a report that brings back all tasks that have a due date in the past.  If I was to run the report today (10/02/2022) the results would be only tasks that have a due date of before 10/02/2022.  Thank you.

Kind Regards

Ann

[Steve Giller]

This filter should work when reporting against the h_sys_tasks table.

The {{DATE:startoftoday}} value can be populated using the Use Variable button in the Add Value dialog

 

[Ann]

Morning @Steve Giller

That is fantastic, thank you so much.  I really do appreciate your help.

I hope you have a lovely weekend.

Kind Regards

Ann