Ignoring the TIME portion of a date when filtering using date comparison | Community
Skip to main content
October 10, 2019
Question

Ignoring the TIME portion of a date when filtering using date comparison

  • October 10, 2019
  • 0 replies
  • 322 views
Hi Community! Does anyone know if it is possible to filter by comparing dates, where the comparison ignores the time portion of the date and compares the date itself only? I am using Text Mode: projectedStartDate=FIELD:plannedStartDate projectedStartDate_Mod=gt However, this doesn't give me precisely what the users need. For example, I would want to filter out a task where the Planned Start Date was 10/4/19 8:00 AM and the Projected Start Date was 10/4/19 3:04 PM. I tried to find a way to use CLEARTIME to find a solution, but was not successful. Thanks! Leah Johnson MMC - General - INACTIVE
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.