How can I get number of days ticket has been opened

[reddy8055]

Hi,

I have created a string field on incident and trying to get total days of incident opened based on created date and todays date. Its showing time as well, how can I remove time and show only days.

var gr = new GlideRecord('incident');
gr.query();
while (gr.next()) {
    var dat = new GlideDateTime();
    var datedif = gs.dateDiff(gr.sys_created_on, dat);
    gr.u_total_days = datedif;
    gr.update();

}

Thanks,

[reddy8055]

Its working now. Thank you

[Yousaf]

Good. No problem

[kamlesh kjmar]

Hi @reddy8055 ,

Try below code, it should work for you:

var gr = new GlideRecord('incident');
gr.query();
while (gr.next()) {
    var dat = new GlideDateTime();
    var datedif =gs.dateDiff(gr.getDisplayValue('sys_created_on'), dat, true) ; // Returns difference in second
    datedif = Number(datedif) // Convert this to number
    var days = datedif /86400 //Convert seconds to days
    gr.u_total_days = datedif;
    gr.update();

}

I Hope this helps.

Please mark this helpful if this helps and Accept the solution if this solves your issue.

Regards,

Kamlesh

[reddy8055]

Hi,

where did you define number on line 6?

I am getting like below

Thanks

[MStritt]

@reddy8055 Where do you add this script? Client Script? Scheduled job?