Customise field value based on formula

Sumit_Arora · September 7, 2021, 6:16am

Hi,

I am trying to update a customise field “Due Days” field type duration with following script

frappe.ui.form.on(“Issue”, {
refresh: function(frm) {
frm.set_value(“due_days”, get_today() - frm.doc.opening_date);
}
});

but it is not working. Can anyone help where is the issue.

kennethsequeira · September 7, 2021, 11:51am

Change this to:

 frm.set_value("due_days",frappe.datetime.get_diff(frappe.datetime.get_today(), frm.doc.opening_date));

We’re using the frappe.datetime.get_diff function which returns the difference in dates in days.

github.com

frappe/frappe/blob/541db956a6e46f82a7136d9c7d981e9e766a30fb/frappe/public/js/frappe/utils/datetime.js#L57


      
          	},
          
          	obj_to_str: function(d) {
          		return moment(d).locale("en").format();
          	},
          
          	obj_to_user: function(d) {
          		return moment(d).format(frappe.datetime.get_user_date_fmt().toUpperCase());
          	},
          
          	get_diff: function(d1, d2) {
          		return moment(d1).diff(d2, "days");
          	},
          
          	get_hour_diff: function(d1, d2) {
          		return moment(d1).diff(d2, "hours");
          	},
          
          	get_day_diff: function(d1, d2) {
          		return moment(d1).diff(d2, "days");
          	},