- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2022 02:59 PM
Hi All,
The below script is working as expected but I need help to modify and remove the weekend from the calculation.
The below advance script is on the calculated tab of field "Aging". The integer type field 'aging' is on scoped application.
(function calculatedFieldValue(current) {
if(current.state == 7){ //7 is closed value of state field on a scoped application
var aging= GlideDateTime.subtract(new GlideDateTime(current.sys_created_on),new GlideDateTime(current.closed_at));
} else {
aging= GlideDateTime.subtract(new GlideDateTime(current.sys_created_on),new GlideDateTime());
}
return aging.getDayPart();
})(current);
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2022 05:47 PM
I'm not sure how you added my code to you instance , I tried and it works well.
See my pics below.
start end and aging
Calculation scripts on field "Aging"
test1
test2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2022 08:49 PM
In my country holiday changes every year.....
I think you need a table to store the holidays,and get the holiday infomation from the table at the first. and modify the below part to judge if it's a holiday....
if( startDateTime.getDayOfWeekUTC() == 6 || startDateTime.getDayOfWeekUTC() == 7){