Need Report showing Specific Created Time Range
The Advanced Matrix Report doesn't allow me to filter the time range I want to see. The Create Time format only allows yyy-mm-dd format and if I run that I get everything and have to manually take out what I don't want to see. I was exporting to CSV format and changing the custom row format in Excel to m/d/yyyy h:mm AM/PM. Unfortunately, since the latest update in ServiceDesk Plus, all the times are showing as AM except for 12:00 PM.
I'd like to create a report that shows all incidents/requests created last month between the hours of 6:00 PM and 8:00 PM, grouped by Created Time that will show the date including time in m/d/yyy hh:mm AM/PM format. I'd like to group it by Request Mode. And hopefully, it will be easy enough to modify the date range and range and hours I want when I am looking to see something different.
I greatly appreciate your help!
I'd like to create a report that shows all incidents/requests created last month between the hours of 6:00 PM and 8:00 PM, grouped by Created Time that will show the date including time in m/d/yyy hh:mm AM/PM format. I'd like to group it by Request Mode. And hopefully, it will be easy enough to modify the date range and range and hours I want when I am looking to see something different.
I greatly appreciate your help!