Text Mode Filter
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?
