Enterprise & Sell

Enterprise & Sell Answers & Best Practices How to add years to a date field?

Click here to join this group and curate your SugarClub experience.

How to add years to a date field?

Amanda Chandler over 3 years ago

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?

Parents

0 Andre Serrazina over 3 years ago

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))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Andre Serrazina over 3 years ago

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))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Amanda Chandler over 3 years ago in reply to Andre Serrazina

This is close, but added 4 days when I need it to add 4 years.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel