I have a very simple problem, and I seem to be going round in circles for it.
I have a report, where I need to add a column, Delay in Days, which will be the difference between Current Date and Delivery Date from Sales Order.
When I am doing a CURDATE() - tabSales Order Item.delivery_date, I am getting a huge number. I think its because Curdate shows a yyyy-mm-dd format, while the delivery date is in dd-mm-yyyy format. How can I change the format of Curdate inside Query Report?
I added the field in Ordered Items to be Delivered, which is a Query report. How do I send a PR for this? Will I have to fork the ERPNext and add my changes in the same way as for other reports? I thought it might be easier to just add the field in the Query report, and thatās why I added that additional line of code over here.