Skip to Content
This question has been flagged
pythoncompute
2 Replies
4506 Views
Avatar
Ernesto Ruiz

In my module I have an entity "Person" with two fields "date_of_birth" (Date)  and "age" (Integer). How can I get the age of a Person from the date of birth?

Avatar
Discard
Avatar
Paresh Wagh
Best Answer

Hi Ernesto:

Make "age" a computed field with the following settings: 

  • Readonly = True

  • Stored = False

  • Copied = False

  • Depends on: date_of_birth

The code for the computation would be

for record in self:
  if record.date_of_birth:
    today = datetime.date.today()
    # Check if the date has passed this year
    if today.strftime("%m%d") >= record.date_of_birth.strftime("%m%d"):
      record['age'] = today.year - record.date_of_birth.year
    else:
      record['age'] = today.year - record.date_of_birth.year - 1
  else:
    record['age'] = 0


Avatar
Discard
Avatar
👈️ Rks
Best Answer

Hi Ernesto:
You can do like this:


from dateutil.relativedelta import relativedelta

age = fields.Integer(string="Age", compute="_calculate_age")

   @api.depend('date_of_birth')
    def _calculate_age(self):

          if self.date_of_birth:

             d1 = self.date_of_birth

            d2 = datetime.date.today()

           self.age = relativedelta(d2, d1).years


Avatar
Discard
Related Posts Replies Views Activity
[Odoo 11 EE] custom app, how to make a custom field compute to = (custom date field) - 5 weeks?
python custom compute
Avatar
Avatar
1
Sep 18
3725
How can I do in compute method to differ two datetime ? Solved
python compute odoo
Avatar
Avatar
1
Jan 17
4038
What means "Too many values to unpack" message? Solved
python
Avatar
Avatar
Avatar
Avatar
Avatar
4
Apr 24
170735
In odoo studio - Transform positive value Field into negative value Field Solved
compute
Avatar
Avatar
2
Mar 24
488
have no data in screen. read data in my own module from different model
python
Avatar
0
Dec 23
610