Show date field that's 90 days from $date_entered

Our proposal contracts expire in 90 days, so I want a field that shows the expiration date. It seems simple but the formula...

addDays($date_entered,90)

...isn't working. The field comes back as blank. Using $date_entered as the date, how do I add 90 days, then have that date displayed? What kind of field should be using(e.g. date or datetime)?

Parents

0 Jill Shaheen over 8 years ago

Hi Christopher Garcia - Just create a Date field in Studio with a default value of "three months." This will automatically set the date 90 days from the time you are creating the record.
0 Christopher Garcia over 8 years ago in reply to Jill Shaheen

This info is very helpful to know going forward, however it doesn't totally solve my issue because it only works on newly created opportunities. I've got a significant number of opportunities in the system already and I'd like to know their expiration dates as well. Additionally, 90 days≠3 months because each month has a different number of days in it.

Reply

0 Christopher Garcia over 8 years ago in reply to Jill Shaheen

This info is very helpful to know going forward, however it doesn't totally solve my issue because it only works on newly created opportunities. I've got a significant number of opportunities in the system already and I'd like to know their expiration dates as well. Additionally, 90 days≠3 months because each month has a different number of days in it.

Children

No Data