Se rendre au contenu
Menu
Cette question a été signalée
3 Réponses
2377 Vues

hello 

HOW I CAN CALCULATE DIFFERENCE BETWEEN TWO DATE

for record in self:

    record['x_studio_total_jours'] = record['x_studio_date_departe'] - record['x_studio_date_arrive']


the code is correct ?

Avatar
Ignorer
Auteur Meilleure réponse

Thank you 
it working

Avatar
Ignorer
Meilleure réponse

Hi 

Try this code 

for record in self:

  record['x_studio_total_days'] = 0

  if record['x_studio_date_arrive'] and record['x_studio_date_departure']:

    record['x_studio_total_days'] = (record['x_studio_date_departure'] - record['x_studio_date_arrive']).days

    


Avatar
Ignorer
Meilleure réponse

Hi,

Refer to the code

from datetime import datetime

for record in self:
if record['x_studio_date_departe'] and record['x_studio_date_arrive']:
depart_date = fields.Datetime.from_string(record['x_studio_date_departe'])
arrive_date = fields.Datetime.from_string(record['x_studio_date_arrive'])

difference = (arrive_date - depart_date).days
record['x_studio_total_jours'] = difference
else:
record['x_studio_total_jours'] = 0 # Handle the case where one or both dates are not set

In this code:

  1. We check if both x_studio_date_departe and x_studio_date_arrive fields have values
  2. We use the fields.Datetime.from_string() method to convert the date strings to datetime objects.
  3. We calculate the difference between the two dates and assign it to x_studio_total_jours.
  4. We also handle the case where one or both dates are not set by setting x_studio_total_jours to 0 in that case

Make sure you have the fields module imported in your file for this code to work properly. 

Hope it helps

Avatar
Ignorer
Publications associées Réponses Vues Activité
2
avr. 21
3288
3
févr. 24
2755
1
févr. 24
4982
0
avr. 21
4042
2
juil. 25
423