Ann Posted February 10, 2022 Share Posted February 10, 2022 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 Link to comment Share on other sites More sharing options...
Steve Giller Posted February 10, 2022 Share Posted February 10, 2022 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 Link to comment Share on other sites More sharing options...
Ann Posted February 11, 2022 Author Share Posted February 11, 2022 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now