Compare field date/time with system date and time in scheduled job

[Mishu]

To change state value to Open when custom date/time field (Reactivation Time) value matches with system date/time.

I am trying with below code, which is not giving the output.

Is there anything i am missing here ? Kindly Suggest 

var gr = new GlideRecord('sn_hr_core_case');
gr.addEncodedQuery('state=30^u_reactivation_timeISNOTEMPTY');
gr.query();
while (gr.next()) {

var reopen_date = new GlideDateTime(gr.u_reactivation_time);
var today_date = GlideDateTime();

if (reopen_date == today_date) {
gr.state = '10';
gr.work_notes = 'Updated State to Reopen';
gr.update();
}
} 

[Ankur Bawiskar]

@Mishu 

if you are saying dates should be same then do this

var gr = new GlideRecord('sn_hr_core_case');
gr.addEncodedQuery('state=30^u_reactivation_timeISNOTEMPTY');
gr.query();
while (gr.next()) {

var reopen_date = new GlideDateTime(gr.u_reactivation_time);
var today_date = new GlideDateTime();

if (reopen_date.getDate() == today_date.getDate()) {
gr.state = '10';
gr.work_notes = 'Updated State to Reopen';
gr.update();
}
}

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

[Mishu]

@Ankur Bawiskar 

No, Just for Dates ..i already got that working.
I have to reopen the ticket on the exact date & time selected in the custom date/time field.
How to match the time as well ?

[Ankur Bawiskar]

@Mishu 

where have you written the above script?

[Mishu]

@Ankur Bawiskar ..In Scheduled Jobs