Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Converting 24x7x365 "Clock" to M-F 08:00-20:00
So I've got a pretty nifty solution that will convert the "support case management" clock (native 24x7x365) to an operating hours basis - in this case 0800-2000 Monday to Friday.
Part of this solution includes a formula (for now, in a saved search) that calculates how many "business hours" a particular case has been open. Here's what it looks like:
((({today}-{startdate})*24)-((TO_CHAR({today},'DDD')-TO_CHAR({startdate},'DDD'))*12))
So basically it takes 12 hours off itself for every calendar day it has been open. But here's the problem... how can I tell it that - IF {today}-{startdate} "straddles" a weekend (or 2, or 3, etc.), subtract 24 hours per weekend day?
0