I'm trying to add a calculated field that will take the closed date of an opportunity, add the contract length (years), and provide a new date when the contract expires. No luck on formulas so far, any suggstions?
I'm trying to add a calculated field that will take the closed date of an opportunity, add the contract length (years), and provide a new date when the contract expires. No luck on formulas so far, any suggstions?
Hello Amanda,
If the contact duration is always in years you could try something like this:
addDays($date_closed,multiply($contract_duration_years_c,365))
This is close, but added 4 days when I need it to add 4 years.
This is close, but added 4 days when I need it to add 4 years.
Can you share the exact formula that you are using?