Skip to Content
This question has been flagged
1 Reply
2123 Views
Avatar
nasim

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 don't know what is problem?

Thanks for your help

Avatar
Discard
Avatar
Yenthe Van Ginneken (Mainframe Monkey)
Best 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

Avatar
Discard