Background Script to update Date Fields

[Community Alums]

Hi all,

I have to update some records in Change table i.e i have to set work start with created date , work end with created +30 seconds .

I have written like below but not working

Can you please help

var gr= new GlideRecord('change_request');
gr.addEncodedQuery('short_descriptionLIKEISPW-change^active=true^sys_created_by=ispw');
gr.setLimit(2);
gr.query();
while(gr.next())
{
gr.work_start = gr.sys_created_on;
gr.requested_by_date = gr.sys_created_on;
var date = new GlideDateTime('sys_created_on');
gr.work_end = date.addSeconds(10);
gr.update();
}

[Omkar Mone]

Hi 

Can you try with 

var date = "";

var gr= new GlideRecord('change_request');
gr.addEncodedQuery('short_descriptionLIKEISPW-change^active=true^sys_created_by=ispw');
gr.setLimit(2);
gr.query();

while(gr.next())
{

var createdOn = gr.sys_created_on;
gr.work_start = gr.sys_created_on;
gr.requested_by_date = gr.sys_created_on;
date  = new GlideDateTime(createdOn);
gr.work_end = date.addSeconds(10);
gr.update();
}

I have not tried it. But you give it a try and let me know

Regards,

Omkar Mone

[Community Alums]

Thanks for reply,

Not working

[Omkar Mone]

Hi 

Try this once - 

var date = "";

var gr= new GlideRecord('change_request');
gr.addEncodedQuery('short_descriptionLIKEISPW-change^active=true^sys_created_by=ispw');
gr.setLimit(2);
gr.query();

while(gr.next())
{

var createdOn = gr.getDisplayValue('sys_created_on');
gr.work_start = gr.getDisplayValue('sys_created_on');
gr.requested_by_date = gr.getDisplayValue('sys_created_on');
date  = new GlideDateTime(createdOn);
gr.work_end = date.addSeconds(10);
gr.update();
}

[Community Alums]

not working