commit b3354198f129275d330b9619f4be9610b2875587
author 0Pranav <prnvnachnekar@gmail.com> Fri Nov 22 12:38:43 2019 +0530
committer 0Pranav <prnvnachnekar@gmail.com> Fri Nov 22 12:38:43 2019 +0530
tree 430b018bc07efe9805399fe81eb872cdc1fdbcc9
parent f5112905dcc806ddde0ef5f94c80e7a44fd0e7a9

Fix sql query in set_expired_status

erpnext/selling/doctype/quotation/quotation.py

diff --git a/erpnext/selling/doctype/quotation/quotation.py b/erpnext/selling/doctype/quotation/quotation.py
index ba34dff..ac2c242 100644
--- a/erpnext/selling/doctype/quotation/quotation.py
+++ b/erpnext/selling/doctype/quotation/quotation.py
@@ -187,7 +187,7 @@
 
 def set_expired_status():
 	frappe.db.sql("""UPDATE `tabQuotation` SET status = 'Expired' 
-		WHERE status != 'Expired' AND 'valid_till < %s""" , (nowdate()))
+		WHERE status != 'Expired' AND 'valid_till' < %s""", (nowdate()) )
 
 @frappe.whitelist()
 def make_sales_invoice(source_name, target_doc=None):