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!
Need to Calculate Hours between two times with a twist
I am trying to calculate the hours between two times in a saved search. I have that part down but what I don't have down is one requirement. If the first date is after 3:00 on a weekday then I need to measure the time between 6:00 am the next weekday and the second time. Here is what I have
CASE WHEN TO_CHAR({custbody_ready_for_approval},'D') BETWEEN 2 AND 6 AND TO_CHAR({custbody_ready_for_approval},'HH24' ) < 15 THEN regexp_substr(substr({custbody_ready_for_approval}-{custbody_approval_date_},instr({custbody_ready_for_approval}-{custbody_approval_date_},' ')+1), '^[^:]*') ELSE