Skip to Content
This question has been flagged
fieldsdatedatetimeintegertimedelta
2 Respostes
7889 Vistes
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
Descartar
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
Descartar
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
Descartar
Related Posts Respostes Vistes Activitat
SUM USING TWO DATES and INT.
fields date compute integer
Avatar
Avatar
Avatar
2
de març 22
4141
create field calculated with dates Solved
fields date datetime calculate
Avatar
Avatar
2
de maig 21
4679
Need Studio compute code to show number of days from today vs. a date field Solved
date datetime
Avatar
Avatar
2
de gen. 24
3567
Adding days to a date
date datetime
Avatar
Avatar
Avatar
2
de juny 22
5641
How can I use date format only without time? Solved
date datetime
Avatar
Avatar
2
de juny 18
6994