Skip to Content
This question has been flagged
datedatetime
2 Replies
2738 Rodiniai
Portretas
Mike Osswald

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'.




Portretas
Atmesti
Portretas
Mike Osswald
Autorius Best 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​
Portretas
Atmesti
Portretas
Christopher Walters (cws)
Best Answer

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

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
Adding days to a date
date datetime
Portretas
Portretas
Portretas
2
birž. 22
4692
How can I use date format only without time? Solved
date datetime
Portretas
Portretas
2
birž. 18
6192
[SOLVED] How can I hide the time of Datetime field of a quotation (doc.date_order)? Solved
date datetime
Portretas
Portretas
Portretas
2
lapkr. 16
13892
how to find number of days between two dates? Solved
date datetime
Portretas
Portretas
Portretas
2
vas. 24
12710
How to change display of a specific datetime field in a different format on list and form view?
date format datetime
Portretas
0
spal. 23
3043