Schedule report should run only on weekdays(mon to friday) from 1 pm to 10pm IST??

Divya K1
Tera Guru

Schedule report should run only on weekdays(mon to friday) from 1 pm to 10pm IST?? exclude weekends

7 REPLIES 7

Harsh_Deep
Giga Sage
Giga Sage

Hello @Divya K1 ,

 

In the Schedule report use below code after checking the checkbox "conditional".

Harsh_Deep_0-1728546158032.png

 

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.

 

Thanks harsha,

 

but i need to run the scheduled report between 1pm to 10pm IST ?

 

how to do this in script?

 

 

Hello @Divya K1 

 

In the given screen shot time is there, in that time column you can mention 13:00:00 to 22:00:00 any time, and in the run as tz then choose IST.

 

For your reference I have attached below screen shot.

Harsh_Deep_0-1728550422136.png

 

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.

 

 

You just put in the time you need it to run. If you want it to run at 5 pm IST, you put the time at 5pm IST. The script Harsh_Deep provided will ensure it's on a weekday.

It makes no sense to have a scheduled report run more than once a day. If that is your question, please explain the business case.

 


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark