This is related to my previous post:
I've decided to post another one since that only focuses on contracts with 1 year (12 months) term. But challenge is that contract term may change based on the number of months inputted by the user (may be 4 months, 6 months, etc.).
That's why I am thinking of creating another formula field with checkbox return type that will serve as an indicator that a record has already reached half of its expiration date. Then use that field to filter easily to get my desired result.
But how will I construct my formula logic to get that?