sorry incorrect equations, correct equation is Beg...
# generalm
Milan Rao
04/30/2020, 10:10 PMsorry incorrect equations, correct equation is Beginning Date + # of months = Ending date
k
KevinJ of Kansas
04/30/2020, 11:09 PMadd_months({datefield},5)
m
Milan Rao
04/30/2020, 11:55 PMthanks
Milan Rao
05/01/2020, 12:27 AMnlapiDateToString(nlapiAddMonths(nlapiStringToDate(nlapiGetFieldValue('custbody_est_revenue_start_date')),{custbody_deal_terms_in_month}),'date')
Milan Rao
05/01/2020, 12:27 AMthis works for me
k
KevinJ of Kansas
05/01/2020, 1:28 PMI suppose if you are doing this in script, yes. that would be the method.
m
Milan Rao
05/01/2020, 3:03 PMi did it in the workflow in the formula section, but it also works in saved search. I was surprised
2 Views