Hello comunity, what scrip can i use for calculating Number of Days Between two dates ex date1 . date2 and returning the value to a field. Thanks.

Hi @Randy_Lowery In python, you can use date_diff function to calculate number of days between two dates How to use it from frappe.utils import date_diff date_diff(end_date, start_date) For more details please check below link frappe/utils/data.py develop S…

Hello @rohit_w thank you for the feedback, i was trying to use this scrip frappe.ui.form.on("Liquidacion", "refresh", function(frm){ frm.set_value("periodo_total_laborado", frappe.datetime.get_day_diff( d.fecha_salida , d.fecha_ingreso )); }); using the frappe.datetime.det_day_diff funtion un…

[image] Randy_Lowery: frappe.datetime.get_day_diff( d.fecha_salida , d.fecha_ingreso ) The code is correct, can you check the type of input whether it’s date type or string

hi i set both fields as date in the Doctype, should it be set as string? for now only works when i enter the dates directly in the scrip and no in the fields for example frappe.datetime.get_day_diff( “2016-07-05”, “2016-05-03” ).

[image] Randy_Lowery: hi i set both fields as date in the Doctype Yes this is correct no need to set it as date, I think there is some other issue. Understand the issue, is that the fields are in child table? Because in below code you have used d.fieldname where d is not defined. frappe.ui.…

no both fields belongs to the parent doc-type, i had used same type scrip for calculation before and i know it uses the same syntax

[image] rohit_w: d.fecha_salida , d.fecha_ingreso In that case, the code should be like frm.doc.fecha_salida and frm.doc.fecha_ingreso

Thankyou @rohit_w for your awesomeness support finally make it work the scrip for anyone that may find it usefull is: frappe.ui.form.on("DOCTYPE", "refresh", function(frm, cdt, cdn){ var d = locals[cdt][cdn]; frappe.model.set_value(cdt, cdn, "FIELD", frappe.datetime.get_day_diff( d.LAST_DATE , d…

Number of Days Between two dates script

Frappe Framework App Development

rohit_w February 4, 2017, 7:56pm 8

In that case, the code should be like frm.doc.fecha_salida and frm.doc.fecha_ingreso

Count days between two dates