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

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

calculation of dates in odoo

datetime

2 Antwoorden

4378 Weergaven

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

Auteur

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

Auteur

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

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
Difference Between Two Dates (result not showing up when diff = 0 Day) datetime	3 jun. 25	1817
date time DB datetime	1 jul. 23	4645
How to get date max in next month? datetime	4 dec. 22	10405
(odoo 9) set default time in datetime picker datetime	1 okt. 18	5755
[odoo 9.0] fields.Datetime is read with server TZ? Feature or bug? Opgelost datetime	1 okt. 16	5214

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!