quarterly reports taking into account just dates of the specific quarter

mercama
Mega Contributor

Hello

Apologies for the dumb question, but I'm not a developer.
I have a serie of Reports on Service Now, many of them using a "Created date" condition (eg. "Created date" is after 01/01/2024), so we can always glimpse at the overall numbers since we've started our flow in the system.

Every quarter, I have to produce a static reporting and so I need those reports to take into account just dates from the quarter itself, so for instance, for Q1 2024: "Created date" is after 01/01/2024 and before 31/03/2024, for Q2 2024: "Created date" is after 31/03/2024 and before 30/06/2024, and so on.

Is there any easy way to accomplish this, possibly without touching the conditions of each report ?

I was thinking of the "Schedule" functionality. I see there you can insert "Conditions" there.  Is there a way to add a condition to the scheduled, quarterly report, so that the static PDF to be automatically received by email just contains reports with data taken for the specific quarter?

Many thanks in advance!


1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @mercama 

 

What type of report it is ? try this way

AGLearnNGrow_0-1739454841456.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]

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