Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
3 Odpowiedzi
2345 Widoki

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 ?

Awatar
Odrzuć
Autor Najlepsza odpowiedź

Thank you 
it working

Awatar
Odrzuć
Najlepsza odpowiedź

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

    


Awatar
Odrzuć
Najlepsza odpowiedź

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

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
2
kwi 21
3240
3
lut 24
2722
1
lut 24
4945
0
kwi 21
4001
2
lip 25
360