Add month to date field

Question

Hi,

I have a model with a date field as follow :

class myModel(osv.osv)
date_start : fields.date(...)
month_nb = fields.integer(...)
date_end = fields.date(...)

I made an onchange method to calculate the date_end field on when month_nb and date_start change :
@api.onchange('date_start','month_nb')
def _compute_date_end(self):
from datetime import date
from dateutil.relativedelta import relativedelta
self.date_end = self.date_start + relativedelta(months=self.month_nb)

But with this code, I g

Victor Godayer · Accepted Answer

I eventually found the solution with the old api way :

from datetime import datetime
from dateutil.relativedelta import relativedelta
if self.date_start:
self.date_end = (datetime.strptime(self.date_start,'%Y-%m-%d') + relativedelta(months=self.duree_mois)).strftime('%Y-%m-%d')

Zbik · Answer

1. if you use the new api @api.onchange, you create model definition in new api standard, see documentation [1]
class myModel(models.Model)
date_start : fields.Date(...)
month_nb = fields.Integer(...)
date_end = fields.Date(...)

2. You use helpers for date conversion [2]
date_start_dt = fields.Datetime.from_string(self.date_start)
dt = date_start_dt + relativedelta(months=self.month_nb)
self.date_end = fields.Datetime.to_string(dt)

[1] https://www.odoo.com/documentation/8.0/reference/orm.html

相關帖文	回覆	瀏覽次數
Getting an expired date date selection onchange	1 1月 23	2090
Update one2many record within the same view orm onchange V13	1 1月 22	3204
onchange method doesn't work for new records 已解決 orm onchange odoo12	2 1月 19	6429
Value returned in onchange function not reflecting in UI 已解決 orm onchange odoo-10	2 7月 18	6393
Odoo ORM Create Method Doesn't Save created Records in Treeview? orm onchange odoo-10-Enteprise	0 8月 17	4478

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！