We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Create report on incident created between Monday to Saturday

Aswin Chandras1
Tera Contributor

Hi All,

 

I need a report on incident table that incidents created from Monday to Saturday.

How to achieve this.

6 REPLIES 6

Dr Atul G- LNG
Tera Patron

Hi @Aswin Chandras1 

 

Please try this condition and modify the operator on/after/before  or on after as needed. The trend operator is valid & user here.

 

AGLearnNGrow_0-1742894062681.png

 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

Ankur Bawiskar
Tera Patron

@Aswin Chandras1 

you can use this to consider Monday and Saturday both the days included

AnkurBawiskar_0-1742894580991.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar ,

 

I need to see on weekly basis. Like if I see on Monday I just needs to see the tickets created from last Monday to last Saturday. i missed this point.

In that case, the suggestion by @AndersBGS is a good option. You can use the "created last week" operator—give it a try! @Aswin Chandras1 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************