Skip to Content
Menu
This question has been flagged
1 Reply
3855 Views

Looking to show the age of an item created with a form. I have the fields:

checkin_date = fields.Datetime(default=fields.Datetime.now,readonly=True)
today = fields.Datetime(default=fields.Datetime.now)

age=fields.Integer(string="Age")

'checkin_date' is set as the current date and time whenever the form is submitted, and 'today' should be the current date and time. I want to know the age of the tickets (ie. 'today' - 'checkin_date' = 'age' #x number of days).

EDIT: the way I have 'today' set up is apparently not correct. If I put a field on the form using 'today' it appears blank. It is not actually pulling the current date. Think this may be my problem.

I have this set up currently:

    @api.onchange('checkin_date', 'today', 'age')
    def calculate_date(self):
        if self.checkin_date and self.today:
            d1=datetime.strptime(str(self.checkin_date),'%Y-%m-%d')
            d2=datetime.strptime(str(self.today),'%Y-%m-%d')
            d3=d2-d1
            self.age=str(d3.days)

But it results in just a 0 in the field of 'age'. If I change the 'checkin_date', nothing changes and 'age' remains at zero. I am hoping for the 'age' to automatically adjust each day as the date changes so we can easily see how old a item is. 

Note: The checkin_date works properly with the date when items are made and datetime is imported. 


Odoo V11

Avatar
Discard
Best Answer

    @api.onchange('checkin_date', 'today', 'age')
@api.one def calculate_date(self):

I don't test it.



Avatar
Discard
Author

added @api.one and nothing changed. Age is still showing 0.

Related Posts Replies Views Activity
2
May 21
2726
2
Jan 24
945
2
Jun 22
2625
2
Jun 18
4707
2
Nov 16
11685