Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Účtovníctvo
Sklady
PoS
Projektové riadenie
MRP

All apps

All Posts People Badges

Tagy (View all)

odoo accounting v14 pos v15

About this forum

Pomoc

calculation of dates in odoo

datetime

2 Replies

4403 Zobrazenia

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

Autor

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

Autor

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!

Registrácia

Related Posts	Replies	Zobrazenia
Difference Between Two Dates (result not showing up when diff = 0 Day) datetime	3 jún 25	1847
date time DB datetime	1 júl 23	4670
How to get date max in next month? datetime	4 dec 22	10444
(odoo 9) set default time in datetime picker datetime	1 okt 18	5808
[odoo 9.0] fields.Datetime is read with server TZ? Feature or bug? Solved datetime	1 okt 16	5255

This question has been flagged

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