How to schedule a report on between date range in servicenow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2023 09:45 PM - edited 05-18-2023 09:49 PM
Hello Experts,
Please see below screenshot, accordingly we need to scheduled the report on bi-weekly report.
Can anyone help on this issue.
Thanks in Advance
@Ankur Bawiskar @JaspalSingh1122 @Chuck Tomasi @Palani Kumar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2023 10:20 PM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2023 10:29 PM
Is there any possibility through script by checking conditional script in scheduled job ?
Thanks in Advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2023 10:41 PM
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?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-18-2023 11:26 PM - edited 05-18-2023 11:38 PM
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
Thanks in Advance