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

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

SUM USING TWO DATES and INT.

fields date compute integer

2 الردود

4137 أدوات العرض

Neil Matan

I'm trying to formulate the following fields:

Fields are as follows:

Date_one

Date_two

Int_one (input the number of days)

date_total

Here's the computation:

date_total = (Date_two - Date_one) + 1 - Int_one

How should I do this here? and what are the dependents?

for record in self:
  record['size'] = len(record.name)

Thank you in advance!

Kiran K

Hi Neil,

Try,

today = datetime.date.today()
xmasday = datetime.date(2022, 12, 25)
no_of_days = 5
total_days = (xmasday - today).days + 1 - no_of_days

Hope it helps,
Kiran K

Neil Matan

الكاتب

Hi Kiran,

I am getting this error:
ValueError: <class 'TypeError'>: "unsupported operand type(s) for -: 'datetime.date' and 'bool'" while evaluating

Kiran K

its because one of the date fields does not contain any values, So it returns False ,

if today and xmasday:
total_days = (xmasday - today).days + 1 - no_of_days
else:
raise UserError(_('Update Date Field'))

Lucas

Assuming you are using computed fields:

record ['date_total'] = record.date_two - datetime.timedelta(days=record.date_one + record.int_one - 1)

Add an 'if' statement if there is an error when creating new records. (if the dates are custom their default value 'None' which can't be computed)

The dependencies are fields which trigger the recomputation when changed, so that will be specific to your scenario.

- I am not a programmer so the above code can likely be improved. Hopefully someone else can help here?

Neil Matan

الكاتب

Hi Lucas,

I am getting this error: "function missing required argument 'year'

Lucas

Please give the exact conditions to recreate, are you using Studio? Odoo version? etc

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Add Any Number To Date تم الحل fields date datetime integer timedelta	2 ديسمبر 23	7881
Only month and year in a date تم الحل fields date	4 ديسمبر 23	25041
Simple Computed Field help تم الحل fields compute Studio	3 سبتمبر 24	2227
How to get value from other pages? fields payslip compute	0 ديسمبر 23	2098
Why does one field not reach the other field as the default value? fields default compute	0 أكتوبر 21	3696

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!