Help with Filter/Formula

[chamakalayil]

Help with the Filter for Formula tool to Align the due date (Example 11-08-2023) to the closest HRON planned date (Example 10-23-2023.)

[rzdodson]

@chamakalayil when able, would you mind posting the workflow that this comes from? I am thinking that we can use a Summarize/Sort/and Append group to align the records to the nearest available HRON Planned Date.

[Prometheus · Accepted solution]

@chamakalayil I assumed you were saying you wanted to filter down to the record where the HRON PLANNING DATE was closest to the Due Date. Check this out and let me know if I got what you were looking for.