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

CRM
e-Commerce
Apskaita
Atsarga
PoS
Projektas
MRP

All apps

All Posts People Badges

Žymos (View all)

odoo accounting v14 pos v15

About this forum

Pagalba

calculation of dates in odoo

datetime

2 Replies

4428 Rodiniai

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

Autorius

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

Autorius

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!

Registracija

Related Posts	Replies	Rodiniai
Difference Between Two Dates (result not showing up when diff = 0 Day) datetime	3 birž. 25	1858
date time DB datetime	1 liep. 23	4693
How to get date max in next month? datetime	4 gruod. 22	10471
(odoo 9) set default time in datetime picker datetime	1 spal. 18	5840
[odoo 9.0] fields.Datetime is read with server TZ? Feature or bug? Solved datetime	1 spal. 16	5278

This question has been flagged

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