https://netsuiteprofessionals.com logo
Title
m

Milan Rao

04/30/2020, 10:10 PM
sorry incorrect equations, correct equation is Beginning Date + # of months = Ending date
k

KevinJ of Kansas

04/30/2020, 11:09 PM
add_months({datefield},5)
m

Milan Rao

04/30/2020, 11:55 PM
thanks
nlapiDateToString(nlapiAddMonths(nlapiStringToDate(nlapiGetFieldValue('custbody_est_revenue_start_date')),{custbody_deal_terms_in_month}),'date')
this works for me
k

KevinJ of Kansas

05/01/2020, 1:28 PM
I suppose if you are doing this in script, yes. that would be the method.
m

Milan Rao

05/01/2020, 3:03 PM
i did it in the workflow in the formula section, but it also works in saved search. I was surprised