I need some help with a calculated field.
I would like to set automatically the Expiration Notice field to 30 days before the contract's end_date, but so far I have been unable.
I have found sugarlogic functions to Count, Add and calculate days but nothing to subtract them from a future date.
How can I achieve that?
My goal is to create a process where my Contract Management team gets notified in advanced by creating a task and/or via an email about soon-to-expire contracts.
Your help will be greatly appreciated.