Datetime differnce

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project
MRP

All apps

All Posts People Badges

Ključne besede (View all)

odoo accounting v14 pos v15

About this forum

Pomoč

Datetime differnce

7 Odgovori

3166 Prikazi

Ali Mahmoud

Hi,

i'm trying to build a function that gives me the difference between two date-times, but it doesn't work and nothing changes when changing the dates

start_time = fields.Datetime(string='Start Time', default=fields.Datetime.now)
end_time = fields.Datetime(string='End Time', default=fields.Datetime.now)

@api.onchange('start_time', 'end_time')
def _get_time(self):
    t1 = datetime.datetime.strptime(self.start_time, '%Y-%m-%d %H:%M:%S')
    t2 = datetime.datetime.strptime(self.end_time, '%Y-%m-%d %H:%M:%S')
    time_diff = (t2 - t1)
    self.unit_amount = time_diff
 
can anyone tell me the wrong in my code?
Thanks

Ashish Singh

Best Answer

Hi, Ali

In Odoo 13 you don't need to use "strptime".

You can simply need subtract directly from fields. You can refer to the below code,

@api.onchange('start_time', 'end_time')
def _get_time(self):
    self.unit_amount = int(self.end_time - self.start_time)

For Odoo 12 you can use below code, (Updated My Answer for Odoo 12.0)

from datetime import datetime, timedelta
@api.onchange('start_time', 'end_time')
def _get_time(self):
    date_format = '%Y-%m-%d %H:%M:%S'
    t1 = datetime.strptime(str(self.start_time), date_format)
    t2 = datetime.strptime(str(self.end_time), date_format)
    time_diff = (t2 - t1)
    self.unit_amount = float(time_diff.seconds)

Thanks,

Ashish Singh (Team Lead)

Webkul Software Private Limited

Ali Mahmoud

Avtor

Thanks but I'm using Odoo 12

Ashish Singh

Hi, Ali

For Odoo 12 Kindly follow the below code,

from datetime import datetime, timedelta

@api.onchange('start_time', 'end_time')

def _get_time(self):

date_format = '%Y-%m-%d %H:%M:%S'

t1 = datetime.strptime(str(self.start_time), date_format)

t2 = datetime.strptime(str(self.end_time), date_format)

time_diff = (t2 - t1)

self.unit_amount = float(time_diff.seconds)

Thanks.

Ashish Singh

Hi, Ali

If field is float type then you needs to find total second,days etc. via timedelta object like code given my last post.

Cybrosys Techno Solutions Pvt.Ltd

Hi,

I think you must pass a string instead of datetime when using strptime.Can you try after rewriting the code like below

@api.onchange('start_time', 'end_time')
def _get_time(self):
    t1 = datetime.datetime.strptime(str(self.start_time), '%Y-%m-%d %H:%M:%S')
    t2 = datetime.datetime.strptime(str(self.end_time), '%Y-%m-%d %H:%M:%S')
    time_diff = (t2 - t1)
    self.unit_amount = time_diff