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).

[Harish KM]

Hi @Community Alums in that case you would need to create choices like this

Below 30 days

Above 30 days

Above 60 Days

and need to match the choice value in script like below

current.u_incident_time= 'Above 60 days'; // Above 60 Days is choice value .

[Community Alums]

Hello @Harish KM 

I already created but still not appearing.

[Harish KM]

Hi @Community Alums Can you share your choice value names

and BR condition when to run and advanced script to debug

[Community Alums]

@Harish KM 

Please find the attached images.

[Harish KM]

Hi @Community Alums ok I found the issue, the choice values are different in my script. I have updated to the correct values as per yours, it should work now. Check bolded lines

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';

}

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

{

current.u_incident_time= 'above_30';

}

if(days > 60)

{

current.u_incident_time= 'above_60';

}

current.update();