Skip to Content
This question has been flagged
fieldsdatedatetimeintegertimedelta
2 Replies
7276 Zobrazenia
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
Zrušiť
Avatar
Niyas Raphy (Walnut Software Solutions)
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
Zrušiť
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
Zrušiť
Related Posts Replies Zobrazenia Aktivita
SUM USING TWO DATES and INT.
fields date compute integer
Avatar
Avatar
Avatar
2
mar 22
3497
create field calculated with dates Solved
fields date datetime calculate
Avatar
Avatar
2
máj 21
4053
Need Studio compute code to show number of days from today vs. a date field Solved
date datetime
Avatar
Avatar
2
jan 24
2672
Adding days to a date
date datetime
Avatar
Avatar
Avatar
2
jún 22
4608
How can I use date format only without time? Solved
date datetime
Avatar
Avatar
2
jún 18
6143