How to subtract date now and birthday field then pass the age value in a field (readonly)?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
Hi Kasai,
You can calculate age using the following script:-
start = datetime.strptime(object.birthdate, DEFAULT_SERVER_DATE_FORMAT)
end = datetime.strptime(time.strftime(DEFAULT_SERVER_DATE_FORMAT), DEFAULT_SERVER_DATE_FORMAT)
delta = end - start
age = (delta.days / 365)
Please don't forget to import following:-
import time
from dateutil.relativedelta import relativedelta
from datetime import datetime
from openerp.tools import DEFAULT_SERVER_DATE_FORMAT, DEFAULT_SERVER_DATETIME_FORMAT
Hope this helps,, please let me know if it does.