How to add 42 days to an date field?

Question

How can I add 42 days to an date-field?
I need help with that, I want to add 42days to the invouce_payed field and put it on a new date.field like:
pay_date_two
@api.onchange('invoice_payed')
def _check_change(self):
self.pay_date_two
# = self.invoice_payed
self.pay_date_two = self.pay_date_two + datetime.timedelta(days=42)

ayman mohammed adam · Accepted Answer

Dear Wizardz,
try this code
from dateutil.relativedelta import relativedelta
@api.onchange('invoice_payed')
def _check_change(self):
if self.invoice_payed:
date_1= (datetime.strptime(self.invoice_payed, '%Y-%m-%d')+relativedelta(days =+ 42))
self.pay_date =date_1
else:
self.pay_date =False

*I hope I helped you...*

wizardz · Answer

I have fix it with that:
@api.onchange('invoice_payed')
def _check_change(self):
date_1 = datetime.datetime.strptime(self.invoice_payed, "%Y-%m-%d")
self.pay_date = date_1 + datetime.timedelta(days=42)

*Now when I create a new record it gives me this error:*
*date_1 = datetime.datetime.strptime(self.invoice_payed, "%Y-%m-%d")*
*TypeError: must be string, not bool*

self.invoice_payed , why is this a bool when I have a date field ?

Yvan · Answer

Hi Wizardz,
if your date filed is empty (meaning you have not stored any value in it yet), the ORM will return False.
That's why, you must use the if self.invoice_payed to make sure the field contains a valid datetime value.

@api.onchange('invoice_payed')
def _check_change(self):
if self.invoice_payed:
date_1 = datetime.datetime.strptime(self.invoice_payed, "%Y-%m-%d")
self.pay_date = date_1 + datetime.timedelta(days=42)

Best regards
Yvan

関連投稿	返信	ビュー
Only month and year in a date 解決済 fields date	4 12月 23	24259
[Solved] Cannot add a field to existing model- what has gone wrong? - Odoo8 解決済 fields odoo8.0	5 3月 16	10330
Add custom field on ecommerce address address fields ecommerce	2 5月 23	5842
How to use own custom fieldHow Can I use my own new field here fields use odoo8.0	1 6月 16	3130
Cannot delete - sorry error fields odoo8.0	0 5月 15	73

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！