How to schedule a report on between date range in servicenow.

Santhosh15
Tera Guru

Hello Experts,

 

Please see below screenshot, accordingly we need to scheduled the report on bi-weekly report.

 

Santhosh15_0-1684471447982.png

Can anyone help on this issue.

 

Thanks in Advance

@Ankur Bawiskar @JaspalSingh1122 @Chuck Tomasi @Palani Kumar 

12 REPLIES 12

Ankur Bawiskar
Tera Patron
Tera Patron

@Santhosh15 

are you saying you want to change the date range every week? you cannot make it dynamic without scripting.

ensure you run a scheduled job just before the report runs and update the start and end dates.

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

@Ankur Bawiskar 

 

Is there any possibility through script by checking conditional script in scheduled job ?

 

Thanks in Advance

@Santhosh15 

I didn't get your requirement

1) you want report to be sent only 2 times in a month?

2) you want dynamic dates in that filter condition?

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

@Ankur Bawiskar 

 

I need to trigger the report on between the dates 14th to 28th

Suppose, if we added in scheduled report weekly and report should run on wednesday.

Then it should only trigger on between that two dates.

 

Screenshot attached below

Santhosh15_1-1684478307908.png

 

Thanks in Advance