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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.

Month/Year prompt on 2 columns in HR Help Desk report

edited Oct 6, 2020 3:29PM in Reporting and Analytics for HCM 6 comments

Summary

Need prompts showing month/year combination for 2 prompts in OTBI report for Help Desk

Content

I am trying to create a report showing analysis of service requests raised or closed in the past 12 months. I can probably figure out how to use timestampad to restrict results to previous 12 months but I want some prompts in the report to allow the user to select the year/month for both the SR Created Column and the SR closed Column

 

When I set the report up I can format the columns correctly but in the prompt it shows all of the dates/times that SR's were either opened or closed. What I need is the option in the LOV to be the year/month. How do I do that?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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