Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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