Text Mode Filter | Community
Skip to main content
Heather_Kulbacki
Community Advisor
Community Advisor
October 29, 2019
Question

Text Mode Filter

  • October 29, 2019
  • 0 replies
  • 560 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.