How to schedule a report to execute on 2 dates of a month using Scheduled email of report?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2023 11:35 PM
I want to schedule a report which trigger on 1st and 18th of every month .Is it possible to achieve it using Scheduled email of report? I have tried it by giving run: daily with a condition. But not working .Please suggest.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2023 11:48 PM
Hi,
Refer the below link:
https://www.servicenow.com/community/itsm-forum/scheduled-report-send-only-on-monday-wednesday-frida....
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2023 11:55 PM
Hello @sooryamohan ,
You can use Run as periodically and starting date should be month date
OR
Please define the condition in script. Modify the below script according to your requirement

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-17-2023 12:15 AM
Hi @sooryamohan
Yo can write in condition of scheduled script execution and achieve this.
use the below code to find out the dates
var date = new Date();
var day = date.getDate();
if(day == "1" || day =="18"){
return true;
}
else{
return false;
}
Please mark correct if my response has solved your query.
Cheers,
Mohammed Basheer Ahmed.