Expand my Community achievements bar.

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