Number of Days Between two dates script

[Randy_Lowery]

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.

[rohit_w]

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/frappe/blob/develop/frappe/utils/data.py#L103-L104

[Randy_Lowery]

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 under frappe/frappe/public/js/frappe/misc/datetime.js

but cant mange to make it work, can you please advice what could be wrong?

[rohit_w]

@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

[Randy_Lowery]

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” ).

[rohit_w]

@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.form.on("Liquidacion", "refresh", function(frm){
    frm.set_value("periodo_total_laborado", frappe.datetime.get_day_diff( d.fecha_salida , d.fecha_ingreso ));
});

[Randy_Lowery]

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

[rohit_w]

@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

[Randy_Lowery]

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.FIRTS_DATE));
    refresh_field("FIELD");
});