Im trying to do a simple edit in my already built ...
# suiteflowc
Cr223309
04/19/2019, 3:37 PMIm trying to do a simple edit in my already built workflow to add a month to a certain date field based on the tran date. My workflow event formula is to update the due date to be 1 month from the tran date. This is what i have in the formula but it isn't working: nlapiAddMonths({trandate}, 1)
w
Wolf
04/19/2019, 4:15 PMnlapiAddMonths is a JavaScript API thing, formulas are Oracle SQL
Wolf
04/19/2019, 4:15 PMI think what you're looking for is
{trandate} + interval '1' monthWolf
04/19/2019, 4:16 PMm
markderrick
04/19/2019, 4:17 PM@Wolf Both are used in Workflow formulas depending on whether it’s a client or server side action.
w
Wolf
04/19/2019, 4:18 PMAh, interesting. Good to know.
m
markderrick
04/19/2019, 4:19 PM@Cr223309 Try nlapiDateToString(nlapiAddMonths(nlapiStringToDate(“trandate”),1))
👍 1