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.
Rounding up a Date
I am working on a Saved Search for new hires' insurance eligibility.
They become eligible on the first of the month following 60 days after their hire day.
Ideally, what I would like to do is EOMONTH({hiredate}+60)+1
I keep getting an "ERROR: Invalid Expression" though. I've tried all sorts of formulas; even getting creative with CASE/WHEN.
ROUND works, but of course if the day is <16, it rounds down. I need to force it to round up.
Ideas?
0