İçereği Atla
Bu soru işaretlendi
fieldsdatecomputeinteger
2 Cevaplar
3497 Görünümler
Avatar
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!

Avatar
Vazgeç
Avatar
Kiran K
En İyi Yanıt

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

Avatar
Vazgeç
Neil Matan
Üretici

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'))

Avatar
Lucas
En İyi Yanıt

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?


Avatar
Vazgeç
Neil Matan
Üretici

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

İlgili Gönderiler Cevaplar Görünümler Aktivite
Add Any Number To Date Çözüldü
fields date datetime integer timedelta
Avatar
Avatar
Avatar
2
Ara 23
7277
Only month and year in a date Çözüldü
fields date
Avatar
Avatar
Avatar
Avatar
4
Ara 23
24234
Simple Computed Field help Çözüldü
fields compute Studio
Avatar
Avatar
Avatar
3
Eyl 24
1428
How to get value from other pages?
fields payslip compute
Avatar
0
Ara 23
1360
Why does one field not reach the other field as the default value?
fields default compute
Avatar
0
Eki 21
2950