add day to a date field

[Sowmya20]

I have two field "MI service restore(u_time_when_the_resolved_notif) and MI action due date(u_mi_action_due_date). I want to add 7 days to MI service restore and display in MI action due date.

I have written Business rule for this but it's not  displaying the date.

Here is my code:

var gdt = new GlideDateTime(current.u_time_when_the_resolved_notif); 

var aft= gdt.addDays(7);
gs.addInfoMessage("time after adding date: "+ aft);

current.u_mi_action_due_date = gdt.getDate();

current.update();

Can anyone help me on this.

Regards,

Sowmya

[Harsh Vardhan]

so your business rule is running on incident task table or incident table ?

[Sowmya20]

On Incident table

[Ashutosh Munot1]

HI,

I tried my script on one incident form and it works.

As Harsh said please check the field name.

Thanks,
Ashutosh

[Harsh Vardhan · Accepted solution]

ok then you have to do glide record here to update the column on incident task table. 

eg:

var gdt = new GlideDateTime(current.u_time_when_the_resolved_notif);

gdt.addDaysLocalTime(7);
gs.addInfoMessage("time after adding date: "+ gdt.getDisplayValue());

var gr = new GlideRecord('incident_task');

gr.addQuery('incident',current.sys_id); // make sure the relationship field is parent or incident.

gr.query();

while(gr.next()){

gr.<your date field on incident task > = gdt.getDisplayValue();

gr.update();

}

[Sowmya20]

Thank you so much. It's working.

Below is my script.

var gdt = new GlideDateTime(current.u_time_when_the_resolved_notif);

gdt.addDaysLocalTime(7);
gs.addInfoMessage("time after adding date: "+ gdt.getDisplayValue());
var gr = new GlideRecord('u_incident_task');

gr.addQuery('parent',current.sys_id); // make sure the relationship field is parent or incident.

gr.query();

while(gr.next()){

gr.u_mi_action_due_date = gdt.getDisplayValue();

gr.update();