Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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.