Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Can I control the time element of a "Between" filter — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can I control the time element of a "Between" filter

Received Response
14
Views
6
Comments
edited Oct 17, 2017 6:37PM in Reporting & Analytics for B2C Service 6 comments

Content

Hi All,

New to custom reports, but I am starting simple.  I am working on reports to simply show an incident count of tickets opened in our queue by month, and then one for tickets closed by month.  I am using filters to allow selection of queue, group by month/year, and want to add one that allows me to pick the date range.  The date range filter is giving me the problem.

When I add the filter for "between" it automatically sets the date and time to my system date.  The time is causing the problem when I run my reports.  I can choose my date range just fine, but I can not seem to control the time and this causes errors in my results.  E.g.  If my system time was 11:30am when I created the filter, it will always use that time regardless of date I choose.  If I want to count tickets opened/closed on the selected date the time matters and some tickets may not get included if they are

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!