calculation of dates in odoo

datetime

2 Replies

5354 Views

Danny Gonzalez

Hello, I am trying to create a calculated field that will calculate the difference in days between two dates. I have tried this way but it does not work for me

for record in self:
record[(x_dpuerto)] = record(datetime.now()) - record(x_farribo)

thanks

Danny Gonzalez

Author

Hello thanks for answering I have tried this but it still does not return the days between the two dates. Could you help me find the error?

for record in datetime:
        record ['x_ftest'] = record.x_farribo - record.x_eta

and this is the error that returns:
ValueError: <class 'TypeError'>: "'WrappedModule' object is not iterable" while evaluating
"for record in datetime: \ n record ['x_ftest'] = record.x_farribo - record.x_eta"

Begineer

Hi,

record[(x_dpuerto)] is it a static or a dynamic field ..???

If its static you can go with Mr. Niyas's Answer,

If its a dynamic one ie, difference between two dates when you calculate on today is 20 and for tomorrow it will be 21 ..???

Niyas Raphy (Walnut Software Solutions)

Hi,

Try like this,

days = (date_1 - date_2).days

Thanks

Danny Gonzalez

Author

Hello, thank you for answering me so quickly, I am new to using 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

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Related Posts	Replies	Views
Difference Between Two Dates (result not showing up when diff = 0 Day) datetime	3 Jun 25	3156
date time DB datetime	1 Jul 23	5826
How to get date max in next month? datetime	4 Dec 22	11707
fields.datetime.now() show the time of the latest restart - not the current time Solved datetime	11 Jul 19	76966
(odoo 9) set default time in datetime picker datetime	1 Oct 18	6939

This question has been flagged

Enjoying the discussion? Don't just read, join in!