Filter by dates between 2 dates in frappe.call

[OmarJaber]

I had same issue and solve it
follow this steps

Filter date between using FrappeClient get_value

Hello, I have a hosted ERPNext system needs a customization, I want to get a total of the field from the database so I have used get_value function but I have a problem when I using between operand in the filter for a date, this is my code: frappe.db.get_value('Attendance', { 'employee': cur_frm.doc.employee, 'docstatus': 1, 'attendance_date': ["<", '2018-09-21' ], 'attendance_date': [">=", '2018-08-21' ] }, 'sum(actual_working_hours)', function(r) { conso…