How to get incident age

[Community Alums]

Hello,

I have a requirement regarding getting the incident aged based on the created date, incident age will appear in the choice list if incident new will appear (Below 30 days) if the incident above 30 days (Above 30 days) and (Above 60 days) until (Above 90 days).

[Community Alums]

(function executeRule(current, previous /*null when async*/) {

	var createdAt= new GlideDateTime(current.sys_created_on); //get the incident opened_at date
var now = new GlideDateTime(); //get the current date and time
var duration = gs.dateDiff(createdAt, now, true); //calculate the difference
days = Math.floor(duration / 86400); //convert the duration to days
gs.info('Incident age in days: ' + days);

if(days < 30)

{

current.u_incident_time = 'Below 30 days';

}

if(days < 30 && days <= 60)

{

current.u_incident_time = 'Above 30 days';

}

if(days > 60)

{

current.u_incident_time = 'Above 60 days';

}
})(current, previous);

[Harish KM]

Hi @Community Alums tested in PDI, works as expected, please find below script,

Your BR should be after insert/update

script:

(function executeRule(current, previous /*null when async*/) {

var days;

var createdAt= new GlideDateTime(current.sys_created_on); //get the incident opened_at date

var now = new GlideDateTime(); //get the current date and time

var duration = gs.dateDiff(createdAt, now, true); //calculate the difference

days = parseInt(Math.floor(duration / 86400)); //convert the duration to days

gs.info('Incident age in days: ' + days);

if(days < 30)

{

current.u_incident_time= 'Below 30 days';

}

if(days < 30 && days <= 60)

{

current.u_incident_time= 'Above 30 days';

}

if(days > 60)

{

current.u_incident_time= 'Above 60 days';

}

current.update();//I missed current.update

})(current, previous);

Result:

[Community Alums]

Hello @Harish KM 

Not working on me, should i add those choices in the choice list or not?

[Harish KM]

Hi @Community Alums you need to have choices in the field to display , what type of field are you using for Incident time?

[Community Alums]

@Harish KM 

Choice field