how can I write a def _getdaysbetween fot timedelta between 2 date in a module?

Question

hi
how can I write a def _getdaysbetween fot timedelta between 2 date in a module?
my .py code (for a webkit report) is:
def _getdaysbetween(self, date_start, write_date):
sql = "SELECT write_date - date_start from purchase_requisition as pr
where pr.date_start = \'%s\' AND pr.write_date = \'%s\' " %(date_start, write_date)
self.cr.execute(sql)
return self.cr.fetchall()
but when I want to create a report from purchase requisition, this error show:
SyntaxError: EOL while scanning string literal
I

Yenthe Van Ginneken (Mainframe Monkey) · Accepted Answer

Hi Nasim,
When you look at your SQL query you can see the following:

sql = "SELECT write_date - date_start from purchase_requisition as pr

Your SyntaxError is literally telling what is wrong, you're missing a ' or " in your script and it is right at the end of your SQL statement. You open up the sql statement with " but never close it. This should fix it:

sql = "SELECT write_date - date_start from purchase_requisition as pr"
Yenthe

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!