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!
Saved Search - check if date/time is outside of work hours.
I have tasks that are automatically generated. I want to know however, if this was done outside of work hours.
I can check for the day, to see if it's a weekday or weekend. However, how can I check, for example if the time that I get back with a formula is say before 8am and after 3:45pm?
CASE WHEN ({createddate}, 'HH24:MI') >= 15:45 THEN 1 ELSE 0 END
doesn't work. ERROR: Invalid Expression.
I get that.. The time it is comparing to may not work, plus the createdate format is something that doesn't work for date/time, but only for text, from what I can see.