Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Text Mode Filter

Avatar

Community Advisor

I have the following text mode on a filter:

actualCompletionDate=FIELD:plannedCompletionDate

actualCompletionDate_Mod=lt

So I want the objects to pull into the report if the Actual Completion Date is less than the Planned Completion Date. BUT I want it to just look at date, NOT time.

I feel like CLEARTIIME(date) is what I need to use, but not sure where to add it. I've tried a bunch of different scenarios, but nothing seems to work.

Any ideas? Or am I asking too much?

0 Replies