Hi,
I am trying to create new Query report in Sales invoice doctype.
I added two controls in for filter namely From Date and To Date.
These controls should be checked with posting date field in sales invoice screen.
In Java Script, First filter given like this: “fieldname”:“posting_date”, and second filter also given like this: “fieldname”:“posting_date”
I have written query like this: posting_date >= %(posting_date)s and posting_date <= %(posting_date)s
System not fetching as expected. Could you help to correct the above statement
thanks