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.

[Troya1]

As a workaround, I created a today's date field with the following code.

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

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