Hello, I have two Datetime fields and one Duration type field. What I want is to calculate the difference between these two date fields in D, H, m, s using the client script (Javascript) For example I have these two dates which are already have them let d1 = "08-05-2022 14:00:25" let d2 = "09-05…

//get new date given a date, and a duration let exp_end_time = moment(exp_start_date).add(row.expected_installation_duration, 'seconds'); //calculate new duration, based on two dates let time_diff_in_seconds = moment(row.actual_end_time).diff(row.actual_start_time, 'seconds', true); frappe.model…

Frappe.io Frappe Cloud Documentation Partners Frappe School Marketplace Community Chat (new!)

Frappe Forum

How to get the difference Duration from two Datetime

ERPNext

EugeneP May 19, 2022, 3:16pm 6

Hi @Mohsin1990

Use date_diff, and convert the difference to minutes