Channels
data-privacy
women-in-netsuite
r-e-networks
migration-discussion
bundles
suite-app
upvote-enhancements
demandplanning
italy
spain
order-to-cash
formulas
case-management
scripting
procure-to-pay
sfa
srp
payroll
marketing
suiteflow
dev-ops
nspb
beta-testers
defects
multibook
suite-billing
scis
suite-people
performance
administration
request-a-channel
suitetalkapi
general
manufacturing
accounting
inventory
suitescript
integrations
taxes
jobs
sdf
random
suiteworld
announcements
training
suitecommerce
csvimports
projects
suitebuilder
sitebuilder
advancedpdf
fixed-assets-mgmt
beginners
arm
oneworld
content-alerts
suiteql
australia
crm-sfa
suiteanalytics
releases
Powered by
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
#general
Join Slack