AnsweredAssumed Answered

How to subtract days from date

Question asked by Eric Gonzalez on Apr 13, 2016
Latest reply on Apr 20, 2016 by Kristjan Geir Mathiesen

Hi guys,


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.