How To Add Days Based On Another Date Field?

Hello Jean Pierre Rojas, 

Using SugarLogic you could try something like this formula on the subscription end date field: 

addDays($subscription_start_c,number($subscription_duration_c))

To have this working your 'Subscription Duration' will need to have the number of days for each value, something like this: 

This would be the end result: 

Does this work for you? 

It works almost perfectly!

I tried selecting 2 months from a Subscription Start Date of June 11, 2021

However, the result for Subscription End Date is August 10, 2021

Instead of August 11, 2021.

Though I'm not sure if it's already overkill if we put into the equation the different number of days in each month.

This would be the limitation as out of the box we only have the addDays () function.

If you want to add months, the best way would be to create a custom SugarLogic function addMonths() and then use it on your formula. 

This should help you get started: 

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_11.0/Architecture/Sugar_Logic/Extending_Sugar_Logic/index.html

I see, thank you. We have decided to go with

31 = 1 Month
61 = 2 Months
91 = 3 Months

1 extra day versus 1 less day is better for our customers :) 

Since if subscription starts at July 1, if 30 days, it will be July 31st subscription end date.

While 31 days will be September 1.

If that works for you then it's perfect and saves you from some coding. 

I bet the customers will also be happy with an extra subscription day. 

Unless subscription starts in February 

Yea, if to know the pitfalls about adding days to dates, one would think twice about using adddays to automate the calculation like this :)

When the calc field calculates the wrong value, it is impossible to fix the value manually. 

That is why IMHO logic hooks configuring or using BPM is the best option to automatize such calculations (help the human with calculation, so that human could adjust the value) rather than to automate calculation (make it instead of a human with no chance to adjust the results).

Automatizing could be done with no Sugar coding experience

Yea, if to know the pitfalls about adding days to dates, one would think twice about using adddays to automate the calculation like this :)

When the calc field calculates the wrong value, it is impossible to fix the value manually. 

That is why IMHO logic hooks configuring or using BPM is the best option to automatize such calculations (help the human with calculation, so that human could adjust the value) rather than to automate calculation (make it instead of a human with no chance to adjust the results).

Automatizing could be done with no Sugar coding experience