Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Planned completion date > defaultBaselineTask:plannedCompletionDate

Avatar

Level 3
Hi guys, Are there any gurus who can help me write a quick filter query to only return fields where Planned completion date > defaultBaselineTask:plannedCompletionDate? I've hacked as far as I can to here...and it doesn't work DE:Milestone_Deliverable=Yes DE:Milestone_Deliverable_Mod=in project:status=DED CPL REJ project:status_Mod=notin plannedCompletionDate=defaultBaselineTask:plannedCompletionDate plannedCompletionDate_Mod=lt Thanks in advance!
1 Reply

Avatar

Level 7
this text mode will bring back just Children tasks where the default baseline Completion date <> current completion date. you'll have to add the project statuses here (and milestone filter you have). baseline:isDefault=true baseline:isDefault_Mod=eq plannedCompletionDate=FIELD:task:plannedCompletionDate plannedCompletionDate_Mod=ne task:numberOfChildren=0 task:numberOfChildren_Mod=eq