Se rendre au contenu
Cette question a été signalée
datedatetime
2 Réponses
2731 Vues
Avatar
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'.




Avatar
Ignorer
Avatar
Mike Osswald
Auteur Meilleure réponse

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​
Avatar
Ignorer
Avatar
Christopher Walters (cws)
Meilleure réponse

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

Avatar
Ignorer
Publications associées Réponses Vues Activité
Adding days to a date
date datetime
Avatar
Avatar
Avatar
2
juin 22
4676
How can I use date format only without time? Résolu
date datetime
Avatar
Avatar
2
juin 18
6177
[SOLVED] How can I hide the time of Datetime field of a quotation (doc.date_order)? Résolu
date datetime
Avatar
Avatar
Avatar
2
nov. 16
13879
how to find number of days between two dates? Résolu
date datetime
Avatar
Avatar
Avatar
2
févr. 24
12697
How to change display of a specific datetime field in a different format on list and form view?
date format datetime
Avatar
0
oct. 23
3039