Calculation the duration (time) between the interaction created and current time.

[MR1]

Hi All,

I have a custom field 'u_Agent_duration'(duration type) and it's on the Interaction table. 
I would like to calculate the difference between created datetime and current datetime. Then populate the Agent duration field with the duration difference 

I wrote this below BR on interaction table on After, Insert and update checked. 

Unfortunately, it is not working.

(function executeRule(current, previous /*null when async*/) {

	// Add your code here

	var creationTime = new GlideDateTime(current.sys_created_on);
	var nowTime = new GlideDateTime();
	var duration = GlideDateTime.subtract(creationTime, nowTime);
	current.u_Agent_duration = duration; // give proper field name here

})(current, previous);

[MR1]

We don't have any close date field.

Just we need populate the Agent duration of the interaction record when (sys_created_on)created datetime is more than current datetime.

Thanks

[Aman Kumar S]

When you say sys_created_on is more than current date time, what do you mean?
Is it possible to have created date being greater than current time?

var currentDate = new GlideDateTime(gs.nowDateTime());
var openedAt = new GlideDateTime(current.getValue("sys_created_on"));
return new GlideDuration(GlideDateTime.subtract(openedAt, currentDate));