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'm after some help with setting DUE DATE on a Task...

Task is created via Webservices, an d START DATE is the day of creation. I need the DUE DATE to be START DATE + 2 days (excluding weekends). Best way to do this via Workflow?

Thanks

You can set due date with {datecreated}+2

As a pro tip you may need to consider more to take into account Thursday and Friday tasks which will have due dates on weekends. 

You can do with a semi-elaborate formula. First validate what day of the week the start date is on then add the proper days from there

CASE WHEN TO_CHAR({startdate}, ‘DW’) = ‘05’ THEN {startdate}+4 WHEN TO_CHAR({startdate}, ‘DW’) = ‘06’ THEN {startdate}+3 ELSE {startdate}+2 END

I’ve run into issues with straight adding to date fields in workflows so you may get a formatting error
If so try ADDDAYS function instead of {startdate}+2 etc