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

Related Posts	Respostes	Vistes
Getting an expired date date selection onchange	1 de gen. 23	3058
Update one2many record within the same view orm onchange V13	1 de gen. 22	4054
onchange method doesn't work for new records Solved orm onchange odoo12	2 de gen. 19	7462
Value returned in onchange function not reflecting in UI Solved orm onchange odoo-10	2 de jul. 18	7469
Odoo ORM Create Method Doesn't Save created Records in Treeview? orm onchange odoo-10-Enteprise	0 d’ag. 17	5499

This question has been flagged

Enjoying the discussion? Don't just read, join in!