Compare two date fields & calculate days between the two?

Edwin Fuller · ‎08-26-2016

I have a field called "Original Expected Completion Date" that is populated automatically when another field called "Expected Completion Date" is filled in by a user. I need to capture the number of days it took to populate the field by comparing the "Created" date field with the "Updated" date field. I already have a business rule script running on the "Expected Completion Date" field as well.

Any thoughts of how I could accomplish this, example scripts would be great.

Thanks,

Edwin

Abhinay Erra · ‎08-27-2016

My bad. Here you go. This is how you set a duration field.

Script:

var gdt1 = new GlideDateTime(current.sys_created_on.getDisplayValue());

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

var dur = GlideDateTime.subtract(gdt1, gdt2); //the difference between gdt1 and gdt2

var dur1= new GlideDuration();

dur1.setValue(dur.getValue());

current.<name of duration field>=dur1.getDurationValue();

View solution in original post

Rahul Kathuria · ‎08-26-2016

Hi Edwin, I could not understand the requirement here. Could you please elaborate.

However you can go through this thread which might help..

https://community.servicenow.com/thread/166041

Thanks

Rahul Kathuria

Please mark the answer correct if this helps***

Abhinay Erra · ‎08-26-2016

When should the clock stop in your case? What do you mean by updated field?

Edwin Fuller · ‎08-26-2016

The clock should stop as soon as the "Original Expected Completion Date" is filled in. Once filled in the "sys_updated_on" field and "Create" field would be compared to get the number of days between the two.

Abhinay Erra · ‎08-26-2016

Write a before business rule

when: before insert and update

Conditions: Original Expected Completion Date" changes AND Original Expected Completion Date" is not empty

Script:

var gdt1 = new GlideDateTime(current.sys_created_on.getDisplayValue());

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

var dur = new GlideDuration();

var dur = GlideDateTime.subtract(gdt1, gdt2); //the difference between gdt1 and gdt2

gs.print(dur.getDisplayValue()); //this will give you the difference in days and hours