How to schedule a report to execute on 2 dates of a month using Scheduled email of report?

sooryamohan
Tera Contributor

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.

 

 

sooryamohan_1-1673940884209.png

 

sooryamohan_0-1673940852965.png

 

3 REPLIES 3

Omkar Kumbhar
Mega Sage
Mega Sage

Hello @sooryamohan ,

You can use Run as periodically and starting date should be month date

OmkarKumbhar_0-1673942051226.png

 

OR 

Please define the condition in script. Modify the below script according to your requirement

OmkarKumbhar_1-1673942106935.png

 

 

If I was able to help you with your case, please click the Thumb Icon and mark as Correct.

Basheer
Mega Sage

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 hit like button if my suggestion has helped you in any way.
Please mark correct if my response has solved your query.

Cheers,
Mohammed Basheer Ahmed.