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

[lakshminarayan4]

Hi ,

You can use the below script to get directly

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

          var start = current.sys_created_on.getDisplayValue();

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

          var duration = new GlideDuration(str.split(' ')[0] + " 00:00:00")

          current.u_days_open = duration;

  })(current, previous);

Thanks

[deepanshanand]

Not working
i am using before insert update br

u_due_date is a duration type field

[deepanshanand]

Still same
not able to see open days data in the list of records.
please see screenshot

[divya mishra]

Hey Deep;

whats the output you are getting from BR ?

Regards,

Divya