Skip to Content
This question has been flagged
datetime
2 Replies
4383 Views
Avatar
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
Avatar
Discard
Avatar
Danny Gonzalez
Author Best Answer 
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"

Avatar
Discard
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 ..???

Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,

Try like this,

days = (date_1 - date_2).days

Thanks

Avatar
Discard
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

Related Posts Replies Views Activity
Difference Between Two Dates (result not showing up when diff = 0 Day)
datetime
Avatar
Avatar
Avatar
3
Jun 25
1824
date time DB
datetime
Avatar
Avatar
1
Jul 23
4648
How to get date max in next month?
datetime
Avatar
Avatar
Avatar
Avatar
Avatar
4
Dec 22
10410
(odoo 9) set default time in datetime picker
datetime
Avatar
Avatar
1
Oct 18
5766
[odoo 9.0] fields.Datetime is read with server TZ? Feature or bug? Solved
datetime
Avatar
Avatar
1
Oct 16
5217