AnsweredAssumed Answered

Formula to add 2 numbers to date

Question asked by Joshua Baer on Jul 21, 2016
Latest reply on Jul 22, 2016 by Ramana Raju Santhana

I have a date field that records when a contract comes in. $contractReturned_c

I have a date field (lets call it: Contact Day) which tells me when to contact that contract submitter in 9 months using a simple calc: addDays($contractReturned_c,274)

 

I would like to add an extension drop down that will allow the contract submitter more time before I contact them. In that drop down, I have 0, 30, 60, 90. As in days. The value is just a number. I want to take the above formula and make it add a 3rd number from my drop down, but I simply can not figure out  how. My best guess was:

add(addDays($contractReturned_c,274),$DropDownExtention_c)

 

Any tips in the right direction would be appreciated. Thoughts?

Outcomes