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!
SQL waaaaay beyond my ability for date range
Hi all,
I have a custom for Period Close Activities. The user clicks a button at the start of the month end period and the record populates a sublist of 20 tasks. Currently the owner of each tasks goes in and puts in an expected end date. I want to prepopulate that expected end date field though.
I need a piece of SQL to use on a formula field to say end of current month plus/minus N days not including weekends.
Can anyone help with how I would achieve this please?
Thank you
Chris