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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
Saved Search Case Formula That References A Date to Last Week
Hi All
I have a project task saved search whose intent is to report on project tasks with an (1) end date or (2) start date within Last Week. But having the two criteria on the same search means the count is in the same column. So I want the project task assignee names (the employees) for (1) in one column and those for (2) in another column.
Any idea how I can do this/ what the correct formula is?
I tried the following using earlier resources by @Robert Nedelkow-Oracle which is throwing an error with 'formula(text). It is found at:
CASE WHEN ({custevent_hw_role_start_date} >= TRUNC({today} - 7 ,'W') and {custevent_hw_role_start_date} <= NEXT_DAY({today} - 7 ,'SATURDAY')) THEN {custevent_hw_resource} ELSE 0 END