Schedule report should run only on weekdays(mon to friday) from 1 pm to 10pm IST??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2024 12:25 AM
Schedule report should run only on weekdays(mon to friday) from 1 pm to 10pm IST?? exclude weekends
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2024 12:43 AM
Hello @Divya K1 ,
In the Schedule report use below code after checking the checkbox "conditional".
Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2024 01:30 AM
Thanks harsha,
but i need to run the scheduled report between 1pm to 10pm IST ?
how to do this in script?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2024 01:54 AM
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.
Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2024 01:58 AM
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