Create a filter to compare two values in a view

[BillPe]

In my task view, I want to create a filter to compare two field values to determine which task lines to display

I want to compare the Task: projected Completion date and the Project: Planned Completion date.

I want to display any task that has a task: projected completion date greater than the Project: Planned Completion date.

I know I need to do this in Text mode.

Can you tell me the text I need to create

[JustinRenteria2 · Accepted solution]

This will give you what you need on a task report:
projectedCompletionDate=FIELD:project:plannedCompletionDate

projectedCompletionDate_Mod=gt

[kautuk_sahni]

@BillPe Just checking in — were you able to resolve your issue?
We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!