First, I think that you need to better define, Monday - Friday, and Friday - Monday. Your Friday’s will overlap, perhaps. Are you thinking about 8 to 5 or 24 hours?
Outside all of that, you could do:
Outside all of that, you could do:
- Create another column in your change table. Maybe something like weekdays or whatever you want to call it. You will want to make it a True/False type. In my script example, it is workday.
- Then you will want to create a Business Rule that will trigger when the planned start date changes on the change_request table. Something like this:
You could put something similar for the Script under Advanced:
(function executeRule(current, previous /*null when async*/) {
var checkTime = current.start_date.getGlideObject();
if(current.work_start){
checkTime = current.work_start.getGlideObject();
}
var checkTime = current.start_date.getGlideObject();
if(current.work_start){
checkTime = current.work_start.getGlideObject();
}
var sched = new GlideSchedule(‘090eecae0a0a0b260077e1dfa71da828’); // change to the schedule you want
if (sched.isInSchedule(checkTime))
{
current.u_is_workday = true;
} else {
current.u_is_workday = false;
}
})(current, previous);
- I wouldn’t recommend putting an actual sys_id in the script. I used it for my testing. — perhaps a sys_property so this can easily be changed
- You would also need to run a fix script to update all of your existing records to populate the new field.
Try and utilize the existing schedules that are in the platform if you can when writing your script.
I hope this helps and points you in a direction to create what you are looking for.
