SUM USING TWO DATES and INT.

Question

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 · Answer

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

Lucas · Answer

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

相關帖文	回覆	瀏覽次數
Add Any Number To Date 已解決 fields date datetime integer timedelta	2 12月 23	7269
Only month and year in a date 已解決 fields date	4 12月 23	24231
Simple Computed Field help 已解決 fields compute Studio	3 9月 24	1423
How to get value from other pages? fields payslip compute	0 12月 23	1358
Why does one field not reach the other field as the default value? fields default compute	0 10月 21	2949

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！