Calculate Days open based on sys_created

[deepanshanand]

HI Experts i am trying to write code to calculate no of days a ticket has been opened based on only sys_created_on .
Below is the code that i tweaked little bit but its not working

below is script include:

var CalculateDuration = Class.create();

CalculateDuration.prototype = {

      calculate_duration : function(start) {

              var duration.seconds = {};

duration.days = parseInt(duration.seconds * 100 / 86400,10)/100;

              return duration;

      }

};

Buisness rule where i am calling

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

        var start = current.sys_created_on.getDisplayValue();

      var td = new CalculateDuration();

    var duration = td.calculate_duration(start);

      current.u_days_open = duration.days;

})(current, previous);

Any leads where i am going wrong

[divya mishra]

Hey Deep,

Directly write a display BR with this

var datedif = gs.dateDiff(current.sys_created_on.getDisplayValue(), gs.nowDateTime());  

gs.addInfoMessage("Days opened"+datedif);

Please Hit ✅Correct, ��Helpful, or ��Like depending on the impact of the response

Have a lovely day ahead

Regards,

Divya Mishra

[divya mishra]

ADDITIONAL HELP: if only days required

display BR

code:

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

// Add your code here

var datedif = gs.dateDiff(current.sys_created_on.getDisplayValue(), gs.nowDateTime());  

var date1= datedif.split(" ");

gs.addInfoMessage("Days opened::"+date1[0]);

})(current, previous);

[divya mishra]

Hey Deep,

ADDITIONAL HELP: if only days required

display BR

code:

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

// Add your code here

var datedif = gs.dateDiff(current.sys_created_on.getDisplayValue(), gs.nowDateTime());

var date1= datedif.split(" ");

gs.addInfoMessage("Days opened::"+date1[0]);

current.FIELDNAME = date1;

current.update(); // this will make infomessage dissapear

})(current, previous);

post me your feedback

Please Hit ✅Correct, ��Helpful, or ��Like depending on the impact of the response

Have a lovely day ahead

Regards,

Divya Mishra

[deepanshanand]

Still same
not able to figure out why days open is still blank.

[divya mishra]

Any luck ?