Skip to Content
This question has been flagged
fieldsdatedatetimeintegertimedelta
2 Replies
6154 Views
Avatar
moh

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 ?? 

Avatar
Discard
Avatar
Niyas Raphy (Walnut IT)
Best 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

Avatar
Discard
Avatar
Emipro Technologies Pvt. Ltd.
Best 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



Avatar
Discard
Related Posts Replies Views Activity
SUM USING TWO DATES and INT.
fields date compute integer
Avatar
Avatar
Avatar
2
Mar 22
2124
create field calculated with dates Solved
fields date datetime calculate
Avatar
Avatar
2
May 21
2719
Need Studio compute code to show number of days from today vs. a date field Solved
date datetime
Avatar
Avatar
2
Jan 24
939
Adding days to a date
date datetime
Avatar
Avatar
Avatar
2
Jun 22
2622
How can I use date format only without time? Solved
date datetime
Avatar
Avatar
2
Jun 18
4700