Filter Planned Completion Date Based on Current Date
We have created an OTBI report with the column "Planned Completion Date" using Maintenance Management - Work Order Performance Real Time subject area. This was created to obtain all work orders that have past due operations.
I have uploaded the catalog file of the report for your reference.
The requirement is to ONLY capture records that has a Planned Completion Date less than or equal to Current Date.
How can the above requirement be achieved?
Appreciate prompt feedback.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):