Question
Ignoring the TIME portion of a date when filtering using date comparison
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