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

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!