Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
datefielddifference
3 Odgovori
27173 Prikazi
Avatar
yassin

I need to calculate the difference between two dates : 

py :

start_date = field.Date()

end_date = field.Date()

xml :

<field name="start_date"/>

<field name="end_date"/>



Avatar
Opusti
Avatar
Avinash Nk
Best Answer

Hello Yassin,

Try something like this from your python file.

You can call the function in different ways.

Check an example from Button Click.

from datetime import datetime


class YourClass(models.Model):
    _inherit = 'your.model'

    @api.multi
    def your_function(self):
        fmt = '%Y-%m-%d'
        start_date = self.start_date
        end_date = self.end_date
        d1 = datetime.strptime(start_date, fmt)
        d2 = datetime.strptime(end_date, fmt)
        date_difference = d2 - d1


Thanks & Regards

Avinash N K

Avatar
Opusti
yassin
Avtor

hi Avinash, thanks for your answer

I try to call the function in a compute filds and display the result but it doesn't work this is my code, it dispays 0 :

...

class EcoStage(models.Model):

name =eco.stage

start_date = fields.Date()

end_date = fields.Date()

duree_stage = fields.Integer(string="duree stage", compute='difference_date', store=True)

@api.multi

def difference_date(self):

fmt = '%Y-%m-%d'

start_date = self.start_date

end_date = self.end_date

d1 = datetime.strptime(start_date, fmt)

d2 = datetime.strptime(end_date, fmt)

date_difference = d2 - d1

in xml :

<fields name="duree_stage "/>

Avinash Nk

Add the 2 fields in the dependency.

---> @api.depends('start_date', 'end_date')

Avinash Nk

Also d2-d1 not gives an integer value.

So do like this. (d2 - d1).days

Avinash Nk

And assign the difference value in the computed field.

Like this. self.duree_stage = (d2 - d1).days

yassin
Avtor

thanks a lot Avinash

Avatar
Kamrul Islam Shahin
Best Answer

It can be done easily in odoo 14:

start_date = fields.Date(string="Start date")
end_date = fields.Date(string="End date")
date_diff = fields.Char("Date difference")

@api.constrains('start_date', 'end_date', 'date_diff')
def _date_difference(self):
    for record in self:
        if record.start_date > record.end_date:
            raise ValidationError('Start date should not greater than end date.')
        else:
            record.date_diff = (record.end_date - record.start_date).days


Avatar
Opusti
Avatar
yassin
Avtor Best Answer

finally it works 

thanks a lot Avinash you save my life

this is the entier final code :

in .py:

...

class EcoStage(models.Model):

_name ='eco.stage'

start_date = fields.Date()

end_date = fields.Date()

duree_stage = fields.Integer(string="duree stage", compute='difference_date', store=True)

@api.multi

@api.depends('  start_date ',' end_date ')

def difference_date(self):

fmt = '%Y-%m-%d'

start_date = self.start_date

end_date = self.end_date

d1 = datetime.strptime(start_date, fmt)

d2 = datetime.strptime(end_date, fmt)

if d2 >d1 :

self.  duree_stage = (d2 - d1).days

else :

raise ValueError('end date should be superior than start day')

...

in xml :

<fields name="duree_stage "/>


Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
HOW TO GET MONTH AS TEXT
date field v15
Avatar
Avatar
1
nov. 22
4142
how to customize year range in date field? Solved
date widget field
Avatar
Avatar
1
avg. 15
6353
Year only needed - how to implement? Solved
fields date field
Avatar
Avatar
Avatar
2
mar. 15
5277
Put automatically the date of today in a field Solved
date field automatically today
Avatar
Avatar
Avatar
4
jul. 24
33636
Calculating with fields without module changes
xml date field openerp
Avatar
Avatar
Avatar
2
mar. 15
6689