Expand my Community achievements bar.

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

Avatar

Level 1
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
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies