Not able to update sys_updated_on filed using background script

[Mark Wood]

Hello experts,

I have written the script below to update the sys_updated_on field value using the script. In my background script, it shows me that the record has been updated, but when I check it, it still shows the same date. I want to set it to yesterday's date.

Please guide me on this. Thank you.

var gdt=new GlideDateTime().getDisplayValue();

gdt.addDaysUTC(-2);
var gr=new GlideRecord('u_ma_frm_event');
gr.addQuery('sys_id','1809434b1b553550a72cfdd2cd4bcb76');
gr.query();
if(gr.next())
{

gr.sys_updated_on=gdt;
gr.update();
gr.setWorkflow(false);
gr.autoSysFields(false);
gs.log(gdt);
gs.log(gr.u_ma_fld_number);

}

[Ankur Bawiskar]

@Mark Wood 

you are using autoSysFields() so it's not updating system field

try this

var gdt=new GlideDateTime().getDisplayValue();

gdt.addDaysUTC(-2);
var gr=new GlideRecord('u_ma_frm_event');
gr.addQuery('sys_id','1809434b1b553550a72cfdd2cd4bcb76');
gr.query();
if(gr.next())
{

gr.sys_updated_on=gdt;

gr.setWorkflow(false); // this line should be before update to avoid any BR from getting triggered
gr.update();
gs.log(gdt);
gs.log(gr.u_ma_fld_number);

}

[Mark Wood]

Hello @Ankur Bawiskar, I tried your given logic but still ist not working.

[Ankur Bawiskar]

@Mark Wood 

so what value is shown in sys_updated_on once your script runs?

[Mark Wood]

@Ankur Bawiskar it's showing me the current t date with the current updation time.