Discussions
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.