Skip to Content
This question has been flagged
fieldsdatedatetimecalculate
2 Replies
2717 Views
Avatar
Danny Gonzalez 
Hello, I am new to odoo and I would like to create a calculated field that gives me the difference in days between two dates. I don't know much about programming but I would like to get a solution to my problem. thanks in advance
Avatar
Discard
Avatar
Begineer
Best Answer

Hi,

Check the odoo documention for respective version here 

https://www.odoo.com/documentation/14.0/  , regarding compute function.

field_1 = fields.Date(string="")

field_2 = fields.Date(string="")

field_3 = fields.Integer(compute='_compute_days', string="")

@api.multi

@api.depends('field_1', 'field_2')
def _compute_days(self):
    for record in self:

        record.field_3 = (record.field_1 - record.field_2).days
Hope it helps,

Thanks

Avatar
Discard
Avatar
Danny Gonzalez
Author Best Answer 
Thank you very much for answering, now when testing your code I realize that I do not know where to insert it, forgive my ingorance is that I am starting to study programming now and becoming familiar with odoo. You could tell me where to put the code, I would appreciate it, I tried here but it didn't work for me:
Avatar
Discard
Related Posts Replies Views Activity
Need Studio compute code to show number of days from today vs. a date field Solved
date datetime
Avatar
Avatar
2
Jan 24
939
How to calculate fields - Odoo V16
fields calculate
Avatar
Avatar
Avatar
2
Sep 23
2479
Add Any Number To Date Solved
fields date datetime integer timedelta
Avatar
Avatar
Avatar
2
Dec 23
6152
Adding days to a date
date datetime
Avatar
Avatar
Avatar
2
Jun 22
2616
Calculate Age of Ticket (Current date - create_date)
date datetime calculate age V11
Avatar
Avatar
1
Jul 18
3855