Filter items by comparing two fields
-
Go to a list of tasks.
-
From the Filter drop-down menu, select New filter.
-
Add a filter for Task:Actual Completion Date > Greater Than > Select a date.
TIP
Choose the filter modifier you want to use for the selected field, if available. -
Click Text mode.
-
In the area displayed, add the following code:
actualCompletionDate=FIELD:plannedCompletionDate actualCompletionDate_Mod=gt
-
Click Apply > Save as new.
Previous pageFilter: display only items in an approval status
Next pageFilter: display parent tasks