Calculate number of days between current date and due date

[ChadLee4]

I am trying to create a calculated value field within a form. The value should be the number of days between the current day and the due date field. "due_date" is a field within the table that I created. Right now there is nothing being displayed.

[Manmohan K · Accepted solution]

Hi @ChadLee4 ,

You can use below script

  var todayDate = new GlideDateTime();
  var dueDate = new GlideDateTime(current.due_date);
  var diff = GlideDateTime.subtract(todayDate, dueDate);
  var days = diff.getRoundedDayPart();
  return days;