This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I have a custom due date field on my sales order.
The calculation is triggered on when the customer is chosen.

Unfortunately this formula doesn's seem to work.

nlapiDateToString(nlapiAddDays(new Date(nlapiGetFieldValue('custbody_aim_due_date')),14))

Any suggestions? thanks (edited)

&gt; doesn't seem to work ?
wrong results
error
not triggered

using the Date constructor is unreliable, it only works for certain date formats

use <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_n3061128.html#bridgehead_N3061544|nlapiStringToDate> instead

Almost at the goal, the result is

Wed Jan 19 2022 00:00:00 GMT+0100 (Mitteleuropäische Normalzeit)

If I use nlapiAddDays(nlapiStringToDate(nlapiGetFieldValue('custbody_issue_date')), 5)

Is there a JS function to format Wed Jan 19 2022 00:00:00 GMT+0100 (Mitteleuropäische Normalzeit) into D/M/YYYY?

always D/M/YYYY implies that you dont want a date field

How can I make sure that this: nlapiAddDays(nlapiStringToDate(nlapiGetFieldValue('custbody_issue_date')), 5)

gives me 19/5/2022?

pick your favorite date formatting library to format your date