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

CRM
e-Commerce
Comptabilité
Inventaire
PoS
Projet
MRP

All apps

Toutes les publications Personnes Badges

Étiquettes (Voir toutl)

odoo accounting v14 pos v15

À propos de ce forum

Aide

calculation of dates in odoo

datetime

2 Réponses

4377 Vues

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

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !

Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !

S'inscrire

Publications associées	Réponses	Vues
Difference Between Two Dates (result not showing up when diff = 0 Day) datetime	3 juin 25	1817
date time DB datetime	1 juil. 23	4645
How to get date max in next month? datetime	4 déc. 22	10405
(odoo 9) set default time in datetime picker datetime	1 oct. 18	5755
[odoo 9.0] fields.Datetime is read with server TZ? Feature or bug? Résolu datetime	1 oct. 16	5214

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !