Skip to main content
Heather_Kulbacki
Level 2
October 29, 2019
Question

Text Mode Filter

  • October 29, 2019
  • 0 replies
  • 558 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.