How to set Calculated Value for Duration (or any other date/time) field

[Valon Sheremeti]

Hi,

I am unsuccessfully trying to dynamically set/calculate 'duration' field value based on difference between opened_at and closed_at fields   in an scoped application.

I tried using script below for 'calculated value' but no luck.

Thanks in advance.

(function calculatedFieldValue(current) {

var startDate = current.opened_at;  

var endDate = current.closed_at;  

var duration = GlideDateTime.subtract(startDate, endDate);

return duration;

})(current);

I tried also:

return GlideDateTime.substract(opened_at,closed_at);

but no luck - -my calculated field show <empty> value.

Thank you.

[abrouf]

I updated the script removing time like GlideDate but same errors.

[Vikram3]

Hello Prateek,

Can you please help me with this

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

[Troya1]

This works with two date fields, but we want to calculate the number of days before go live.

Go Live date - Today's date

The below script is not working.  Please assist

(function calculatedFieldValue(current) {
var gdt = new GlideDateTime();
var goLive = new GlideDateTime(current.u_golive_date.getDisplayValue());
var duration = GlideDateTime.subtract(goLive,gdt);

return duration;
// return the calculated value
})(current);

[Prateek kumar]

Try below:

 (function calculatedFieldValue(current) {
var gdt = new GlideDateTime();
var goLive = new GlideDateTime(current.u_golive_date);
var duration = GlideDateTime.subtract(goLive,gdt);

return duration.getDisplayValue();
// return the calculated value
})(current);

[Troya1]

It just keeps showing