How to report on Demand state that has changed to Submitted in the last 2 weeks

[chrish5]

Our project team has a reporting request where they want to see a list of Demands that have moved to the "Submitted" state within the last 2 weeks.  We may have hundreds of Demands sitting in the "submitted" state at any given time, but of those, we only want to see those that have been moved to the "submitted" state in the last two week.  I've been playing around with creating a report on the Demand table, but have not been successful.  I've also noticed on a Demand that you can view its history list where it shows the state changes it goes thru.  This list if pulling from the Record History (sys_history_set) table, but this is not a table that is available to report on.   Any ideas on how to accomplish this reporting requirement?  

[Mike_R · Accepted solution]

You can try reporting on the Submitted on field.

instanceName.service-now.com/dmn_demand_list.do?sysparm_query=sys_class_name%3Ddmn_demand%5Esubmitted_dateRELATIVEGT%40dayofweek%40ago%4014&sysparm_view=

[Maddie Wolf]

Hi @Mike_R . How reliable is the Submitted on field? I am finding several discrepancies with our raw data that is being pulled from the Submitted on field. For example, several demands that were created in 2023, show a "submitted on" date in 2021. As you can note, that is truly impossible. Are there known reporting issues with this field? Or do you have any thoughts as to how this would be occurring?