ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Frappe Api issue in filtering between two dates


#1

I am using frappe api for fetching data. I want to fetch data lying between start_date and end_date, comparing it with current date.
For single field its working.
The url is

https://localhost:8000/api/resource/Sales%20Invoice/?fields=[%22*%22]&filters=[[%22Sales%20Invoice%22,%22start_date%22,%22=%22,%222018-09-13%22]]

but want to filter current date with start and end date.
Any help ?


#2

https://localhost:8000/api/resource/Sales%20Invoice/?fields=["*"]&filters=[[“Sales Invoice”,“creation”,">=",“2018-09-10”], [“Sales Invoice”,“creation”,"<=",“2018-09-14”]]

It will return all sales invoice between these dates.


#3

thanks


#4