Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Add 30 days to Date field
Hello,
Wanting to add days to the examples below via a workflow. I am good on the workflow piece, just caught up on the formula. The formula below is just for the next business day from the transaction date.
How can I add 30 days to this formula instead of just the next business day?
Examples:
PO Ship date is creation date + 30
PO Requested delivery date is creation date + 45
Formula:
"case when INSTR(to_char({trandate}, 'DAY'),'FRIDAY') != 0 then {trandate}+3 when INSTR(to_char({trandate}, 'DAY'),'SATURDAY') != 0 then {trandate}+2 else {trandate}+1 end"