Skip to Content
Dette spørgsmål er blevet anmeldt
developmentfunctiontimedeltav15
2 Besvarelser
8006 Visninger
Avatar
Ali Mohsen Ammar, Ali Ammar

I want to calculate period in months depends on a fields value

I type that :

start_date = fields.Datetime('Start Date')
end_date = fields.Datetime('End Date', compute='_get_end_date')
duration = fields.Integer(string='Duration')
@api.depends('start_date', 'duration')
def _get_end_date(self):
    for record in self:
        record.end_date = False
        if record.start_date and record.duration:
            record.end_date = record.start_date + \
                              timedelta(months=record.duration)

if I type timedelta as hour or days it work 
any help?




Avatar
Kassér
Avatar
Waleed Ali Mohsen
Bedste svar

timedelta doesn't have Months parameter, it only have the below:

Syntax : datetime.timedelta(days=0, seconds=0, microseconds=0, milliseconds=0, minutes=0, hours=0, weeks=0) Returns : Date

So you can use  relativedelta, and the below is the parameters 

classdateutil.relativedelta.relativedelta(dt1=None, dt2=None, years=0, months=0, days=0, leapdays=0, weeks=0, hours=0, minutes=0, seconds=0, microseconds=0, year=None, month=None, day=None, weekday=None, yearday=None, nlyearday=None, hour=None, minute=None, second=None, microsecond=None)  


from dateutil.relativedelta import relativedelta

record.end_date = record.start_date + relativedelta(months=record.duration)


Avatar
Kassér
Avatar
Sahar Dagher
Bedste svar

try to use relativedelta instead of timedelta

from dateutil.relativedelta import relativedelta

new_date = old_date + relativedelta(months=5)


Avatar
Kassér
Relaterede indlæg Besvarelser Visninger Aktivitet
Odoo External API Løst
development function
Avatar
Avatar
Avatar
2
jan. 26
1260
POS print ticket on demand.
development function
Avatar
Avatar
2
feb. 25
2421
I want to create sub-menu under a sub-menu
development function
Avatar
Avatar
1
jan. 25
2125
how to make user see only his a signed default warehouse Returns & Delivery Orders & Receipts in overview backend
development v15
Avatar
0
maj 23
2861
(Solved) v15: wrong view after change view_id Løst
development v15
Avatar
Avatar
1
sep. 22
5045