Need Studio compute code to show number of days from today vs. a date field

Question

I have a date field in a custom helpdesk ticket for a date, let's call that x_studio_warranty_end

In an integer field (call it x_studio_days_remaining_on_warranty) I want to compute how many days from TODAY that is. I.e. if the warranty end is '1/1/2024', I want my field to show '30'.

Mike Osswald · Accepted Answer

I ended up figuring it out after looking at many different places, maybe not the cleanest...
for record in self:
if record.x_studio_warranty_end:​
​ 	 ​dt = datetime.datetime.now()
​ 	 ​dwarr = record.x_studio_warranty_end
​ 	 ​dwarrdt = datetime.datetime.combine(dwarr, datetime.datetime.min.time())
​ 	 record['x_studio_days_remaining_on_warranty'] = (dwarrdt - dt).days​

Christopher Walters (cws) · Answer

You can also use Studio to change the widget of your date field to "Remaining Days".

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Adding days to a date date datetime	2 kesäk. 22	5660
How can I use date format only without time? Ratkaistu date datetime	2 kesäk. 18	7014
[SOLVED] How can I hide the time of Datetime field of a quotation (doc.date_order)? Ratkaistu date datetime	2 marrask. 16	15049
how to find number of days between two dates? Ratkaistu date datetime	2 helmik. 24	13551
How to change display of a specific datetime field in a different format on list and form view? date format datetime	0 lokak. 23	3925

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!