Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Create report on incident created between Monday to Saturday

Aswin Chandras1
Tera Contributor

‎03-25-2025 02:12 AM

Hi All,

 

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

How to achieve this.

Labels:
0 Helpfuls
  • 635 Views
6 REPLIES 6

Dr Atul G- LNG
Tera Patron
Tera Patron

‎03-25-2025 02:14 AM - edited ‎03-25-2025 02:26 AM

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

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

Ankur Bawiskar
Tera Patron
Tera Patron

‎03-25-2025 02:23 AM

@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  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls

Aswin Chandras1
Tera Contributor
In response to Ankur Bawiskar

‎03-25-2025 11:00 PM

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.

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to Aswin Chandras1

‎03-25-2025 11:08 PM

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 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls