Add Any Number To Date

Question

i have integer field and date field
i want when user set any number in integer field added this value
to date field
EX: if user add 3 days and field date is 22/04/2018
the date will be 25/04/2018
any solution to fix it when i don't know what is the integer value ??

Niyas Raphy (Walnut Software Solutions) · Accepted Answer

Hi,
Write and onchange function for the integer field and using the time Delta you can add this integer to the date.
Suppose if you have a date field date_1 then in on change of the integer field field_1 add the integer to date by timedelta.
In on change of field_1,
New_date = date_1 +timedelta(days=self.field_1)

Thanks

Emipro Technologies Pvt. Ltd. · Answer

Hi,
You can write as following:
@api.onchange('integer_field')
def onchange_next_order_date(self):
if self.date_field :
next_order_d1_obj = datetime.datetime.strptime(self.date_field, "%Y-%m-%d")
next_date = next_order_d1_obj + datetime.timedelta(days=self.integer_field)
self.date_field = next_date.strftime("%Y-%m-%d") Thanks

相關帖文	回覆	瀏覽次數
SUM USING TWO DATES and INT. fields date compute integer	2 3月 22	3513
create field calculated with dates 已解決 fields date datetime calculate	2 5月 21	4065
Need Studio compute code to show number of days from today vs. a date field 已解決 date datetime	2 1月 24	2694
Adding days to a date date datetime	2 6月 22	4635
How can I use date format only without time? 已解決 date datetime	2 6月 18	6152

此問題已被標幟

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