Schedule Job Get Date Value

[Jeff42]

Hi all,

I have a problem on Date field calculation, could any one give me suggestions?

1. I have Contract End Date in  the Tabble

2. Create Scheduled Jobs with Script

var gr = new GlideRecord('sn_hr_core_contract_management');

gr.addEncodedQuery('u_contract_end_dateISNOTEMPTY');

gr.query();

while (gr.next()) {

    var contract_end_date = new Date(gr.u_contract_end_date.getDisplayValue());

    gs.info('Contract End' + contract_end_date);

    var today = new Date();

    gs.info('Today ' + today);

    var oneDay = 24 * 60 * 60 * 1000;

    var diffDays = Math.round(Math.abs((contract_end_date - today) / oneDay));

    gs.info('HRIS Test ' + diffDays);

}

3. below result: you can find that the contract end is not correct with the table value

Thank you

Best Regards

[Ankur Bawiskar · Accepted solution]

@Jeff42 

so basically you want difference between contract end date and today's date in days?

if yes then use this

var gr = new GlideRecord('sn_hr_core_contract_management');
gr.addEncodedQuery('u_contract_end_dateISNOTEMPTY');
gr.query();
while (gr.next()) {

	var contract_end_date = new GlideDateTime(gr.u_contract_end_date);
	var today = new GlideDateTime();

	var dur = new GlideDuration();
	dur = GlideDateTime.subtract(today, contract_end_date);

	var days = dur.getDayPart();
	gs.info("HRIS Test" + days);
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Jeff42]

Working now, thanks so much.