question Re: add day to a date field in ITSM forum

add day to a date field

Sowmya20 — Thu, 16 Jul 2020 11:25:38 GMT

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

Re: add day to a date field

Tanushree Doiph — Thu, 16 Jul 2020 11:35:40 GMT

Refer below link,

https://community.servicenow.com/community?id=community_question&sys_id=8b48cbaddb1cdbc01dcaf3231f961928

Re: add day to a date field

Tejas Tamboli — Thu, 16 Jul 2020 11:41:16 GMT

Hello Sowmya,

Try below code for adding days:

var gdt = new GlideDateTime();

gdt.addDaysLocalTime(30);

current.u_mi_action_due_date = gdt;

Note:addDays() is a deprecated method so try using addDaysLocalTime().

else try like this in Background script:

var nd = new GlideDateTime(gs.nowDateTime());

gs.print('current date is :'+nd);

var fd = new GlideDateTime(nd);

fd.addDays(30);

gs.print('future date will be:'+fd);

I hope this will help you.

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response useful to you and help others to find information faster.

Thanks,
Tejas

Re: add day to a date field

Ashutosh Munot1 — Thu, 16 Jul 2020 11:42:40 GMT

Hi,

I dont know if you try this:

var gdt = new GlideDateTime(current.u_time_when_the_resolved_notif);

gdt.addDays(7);
current.u_mi_action_due_date = gdt.getDate();

current.update();

ASSUMING u_mi_action_due_date is a date field,

Thanks,
Ashutosh

Re: add day to a date field

hvrdhn88 — Thu, 16 Jul 2020 11:51:22 GMT

Make sure business rule is before business rule. also avoid using current.update().

Avoid addDays() and use either addDaysLocalTime() or addDaysUTC()

your updated script:

var gdt = new GlideDateTime(current.u_time_when_the_resolved_notif); 

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

current.u_mi_action_due_date = gdt.getLocalDate();

Doc link for further details.

https://developer.servicenow.com/dev.do#!/reference/api/orlando/server_legacy/c_GlideDateTimeAPI#r_GDT-addDays_N

Re: add day to a date field

Sowmya20 — Thu, 16 Jul 2020 11:51:41 GMT

I have tried like this but still it's not displaying the date.

below is the code:

var gdt = new GlideDateTime(current.u_time_when_the_resolved_notif);

var aft=gdt.addDaysLocalTime(30);
gs.addInfoMessage("time after adding date "+ aft);
current.u_mi_action_due_date = gdt;

Thanks,

Sowmya

Re: add day to a date field

Sowmya20 — Thu, 16 Jul 2020 11:53:28 GMT

Hi,

I have tried above script. But still not displaying.

Both the fields are glide_date_time type.

Thanks,

Sowmya

Re: add day to a date field

Ashutosh Munot1 — Thu, 16 Jul 2020 11:57:55 GMT

HI,

If they are glide date time then use this:

var gdt = new GlideDateTime(current.u_time_when_the_resolved_notif);

gdt.addDays(7);
current.u_mi_action_due_date = gdt.getDisplayValue();

current.update();

Thanks,
Ashutosh

Re: add day to a date field

Sowmya20 — Thu, 16 Jul 2020 11:59:11 GMT

Hi,

I have tried above script and changed to before insert and update.

then I got this message : time after adding date: undefined

Regards,

Sowmya

Re: add day to a date field

hvrdhn88 — Thu, 16 Jul 2020 12:01:19 GMT

ah my bad. missed on line

var gdt = new GlideDateTime(current.u_time_when_the_resolved_notif); 

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

current.u_mi_action_due_date = gdt.getLocalDate();  // if its date time type field use gdt.getDisplayValue()

Re: add day to a date field

Sowmya20 — Thu, 16 Jul 2020 12:09:25 GMT

But I have received message like this

"time after adding date: 2020-07-25 16:40:53"

But it's not adding the date to "due date" field

Thanks,

Sowmya

Re: add day to a date field

hvrdhn88 — Thu, 16 Jul 2020 12:12:21 GMT

just confirming , have you used below line ? if its coming in info message then it should also set the same value. i am assuming you are not using current.update() in your business rule.

current.u_mi_action_due_date = gdt.getDisplayValue();

Re: add day to a date field

Tejas Tamboli — Thu, 16 Jul 2020 12:14:17 GMT

Hi,

Try like this

var gdt = new GlideDateTime(current.u_time_when_the_resolved_notif);

gdt.addDaysLocalTime(30);

var aft=gdt.getDisplayValue();

gs.addInfoMessage("time after adding date "+ aft);

current.u_mi_action_due_date = aft;

Thanks,

Tejas

Re: add day to a date field

hvrdhn88 — Thu, 16 Jul 2020 12:16:55 GMT

also check any other script exist into your system to set the date time into u_mi_action_due_date field ?

are you sure the field name is correct ?

can you add some screenshot ?

Re: add day to a date field

Ashutosh Munot1 — Thu, 16 Jul 2020 12:17:14 GMT

Try this?

Thanks,
Ashutosh

Re: add day to a date field

Sowmya20 — Thu, 16 Jul 2020 12:28:17 GMT

Hi,

I have removed current.update() line.

And one more thing is that "MI action due date" is on Incident task table.

How to display that date to "MI action due date" for incident task.

Both the field type is "glide_date_time".

Re: add day to a date field

hvrdhn88 — Thu, 16 Jul 2020 12:30:37 GMT

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

Re: add day to a date field

Sowmya20 — Thu, 16 Jul 2020 12:32:34 GMT

On Incident table

Re: add day to a date field

Ashutosh Munot1 — Thu, 16 Jul 2020 12:38:08 GMT

HI,

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

As Harsh said please check the field name.

Thanks,
Ashutosh

Re: add day to a date field

hvrdhn88 — Thu, 16 Jul 2020 12:41:01 GMT

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();

}