I need to filter all attendance between 2 dates variables but filter works on filters individually not get dates between var start=someDate var end =someDate frappe.call({ method:"frappe.client.get_list", args :{ doctype:'Attendance', filters:{'attendance_date':['Between',start,'and',end]…

You can use ‘between’ for a date range. frappe.call({ method: "frappe.client.get_list", args: { doctype: "Daily Power Usage", filters: [ ['unit_name', "=", unit_name], ['room_name', "=", room_name], ['power_usage_date', "between", [power_u…

I had same issue and solve it follow this steps [image] Filter date between using FrappeClient get_value ERPNext 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 hav…

I appreciate your response and thank you >> I found its easier to use list in filter: filters:[['attendance_date','>=',from_date] , ['attendance_date','<=',to_date]

inside frappe.call() filters: frappe.call({ method:"frappe.client.get_list", args :{ doctype:'Attendance', filters:[['attendance_date','>=',from_date] , ['attendance_date','<=',t…

Also this can be accepted answer, Thanks for your effort

Frappe.io Frappe Cloud Documentation Partners Frappe School Marketplace GitHub

Frappe Forum

Filter by dates between 2 dates in frappe.call

Frappe Framework Custom Script

OmarJaber April 10, 2021, 5:01pm 2

I had same issue and solve it
follow this steps