Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
WorkFlow to calcuate date
Hi,
I am trying to update the contract end date by workflow, however, the calculation did not work.
I have few fields as below:
A: Original Contract Term
B: Original Contract Start Date
C: Original Contract End Date
Contract Renew Time (number of time that contract has been renew)
E: Contract End Date
I have created a workflow with Record Type = Contract Relatioship, Initiation is trigger by Scheduled from Saved Search (if B > {today})
In State, I have used "Set Field Value" to calculate the contract End Date.
Trigger On = Schedule (by day)
Field = Contract End Date
Value by Formula = Add_Months({C},{A}*{D})
0