Frappe.get_list with filter between two datetime objects

Hi,

its possible to filter between two dates like:

data = frappe.get_list("Weather Data",
filters={"weather_time": ["between",  ("2020-10-01", "2020-10-02")})

But is it possible to use get_list or get_all with a filter with datetime, not just date?

When i try something like this:

data = frappe.get_list("Weather Data",
filters={"weather_time": ["between",  ("2020-10-01 09:00:00", "2020-10-02 18:00:00")}

It falls back on to the current day.

I think this is done in

but i have to admit that i don`t fully understand what this code is doing.

Can i somehow achieve this, or should i go with with frappe.db.sql?

1 Like

Any luck on this?