Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Using Within for search criteria misses 6hrs of a day
Learned this in case record searches while gathering metrics for support.
1. Set only criteria as Date Created (or any other date field) and use Within
2. Set From as 11/10/2010 and To as 11/10/2010
3. Preview search and take note of the number of cases
4. Edit search criteria again
5. Change Within to On and use 11/10/2010
6. Preview search and take note of the number of cases
Depending on when cases were created, you'll likely have fewer cases using Within than On. I learned it's because the To date cuts off at 6pm on that date, but On, appropriately, uses the entire day. I don't know how far reaching this defect is but I wanted folks to be aware it could be affecting them and it could be with every date range.