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

[Maddysunil]

@Community Alums 

You can write Business rule which should run on after insert/update, Below is the script you can use it:

(function executeRule(current, previous) {
    // Calculate incident age based on created date
    var createdDate = new GlideDateTime(current.getValue('sys_created_on'));
    var today = new GlideDateTime();
    var daysDifference = gs.dateDiff(createdDate, today, true); // Get difference in days
    
    // Update incident age choice list field
    if (daysDifference < 30) {
        current.incident_age = 'Below 30 days';
    } else if (daysDifference >= 30 && daysDifference < 60) {
        current.incident_age = 'Above 30 days';
    } else if (daysDifference >= 60 && daysDifference < 90) {
        current.incident_age = 'Above 60 days';
    } else {
        current.incident_age = 'Above 90 days';
    }
})(current, previous);

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks

[Community Alums]

Hello @Maddysunil 

Not working only showing Above 30 days

[Maddysunil]

@Community Alums 

Seems like you daysDifference is falling between 30 to 60. Did you check on newly created incident you should get Below 30 days . 

[Community Alums]

@Maddysunil 

Should created in the choice the Below 30 days, Above 30 days and so on? if not it will show nothing on the Incident Age field

[Harish KM]

Hi @Community Alums 

The gs.dateDiff will return in duration, you need to convert that to days as below

var duration = gs.dateDiff(createdAt, now, true); //calculate the difference
gs.info(duration );
var days = Math.floor(duration / 86400); //convert the duration to days
gs.info('Incident age in days: ' + days);