why my glide DateTime not working

[Ravi Borade]

want to get total number of days from today to date incident 'created'

var incidentGR = new GlideRecord('incident');
incidentGR.addQuery('sys_id', '4728cc7587f81110872b40cf8bbb3543');
incidentGR.query();

if (incidentGR.next()) {
    var today = new GlideDate();
    var endDate = incidentGR.sys_created_on.getDisplayValue().split(' ')[0];
    var diff = GlideDate.subtract(today, endDate);
    var days = diff.getRoundedDayPart();
    gs.info(day);

}

ERROR im getting

[Allen Andreas]

Hello,

What issues are you seeing, what errors are you getting?

What does your info log statement say?

Please give more information from your end to show what analysis you've done.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Aman Kumar S]

Try below code:

var incidentGR = new GlideRecord('incident');

incidentGR.addQuery('sys_id', 'fd903bc92f70911002eb2ca62799b673');

incidentGR.query();

if (incidentGR.next()) {

    var today = new GlideDate();

    var endDate = new GlideDate();

    endDate.setDisplayValue(incidentGR.sys_created_on.split(' ')[0]);

    var diff = GlideDate.subtract(today, endDate);

    var days = diff.getRoundedDayPart();

    gs.info(days);

}

[Aman Kumar S]

@Ravi Borade 

This didn't work for you?

[Ankur Bawiskar · Accepted solution]

Hi,

update as this

var incidentGR = new GlideRecord('incident');
incidentGR.addQuery('sys_id', '4728cc7587f81110872b40cf8bbb3543');
incidentGR.query();
if (incidentGR.next()) {
	var today = new GlideDateTime();
	var endDate = new GlideDateTime(incidentGR.sys_created_on);
	var diff = GlideDateTime.subtract(today, endDate);
	var days = diff.getRoundedDayPart();
	gs.info(day);
}

regards
Ankur