I have a requirement. On opportunity there is a field Min Term (months) and a closedate field(standard). Need to create a check box field "Opp 50% expired". It will be auto-ticked when closedate + minTerm/2 > today.
I tried to achieve by creating the formula field but found that we can't add months to a date. Tried to use some custom formula but they also do not work in all scenarios.
Can we do this using apex ?
Thanks in advance