跳至内容
此问题已终结
datefielddifference
3 回复
25880 查看
形象
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"/>



形象
丢弃
形象
Avinash Nk
最佳答案

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

形象
丢弃
yassin
编写者

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
编写者

thanks a lot Avinash

形象
Kamrul Islam Shahin
最佳答案

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


形象
丢弃
形象
yassin
编写者 最佳答案

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 "/>


形象
丢弃
相关帖文 回复 查看 活动
HOW TO GET MONTH AS TEXT
date field v15
形象
形象
1
11月 22
3231
how to customize year range in date field? 已解决
date widget field
形象
形象
1
8月 15
5376
Year only needed - how to implement? 已解决
fields date field
形象
形象
形象
2
3月 15
5277
Put automatically the date of today in a field 已解决
date field automatically today
形象
形象
形象
4
7月 24
32324
Calculating with fields without module changes
xml date field openerp
形象
形象
形象
2
3月 15
5512