Odoo Help


How to get the total of days/months between two given dates ?

sneha antony
on 3/21/14, 7:59 AM 2,549 views

In one of my interface,I have two dates.One is the start date and other one is the end date.In the next field I want the total no.of days/month between these two dates to be automatically generated.There is no other specification regarding the dates or the total no.of days between the two dates.How to get the total number of days between the two given dates?


Ghanshyam Prajapati

--Ghanshyam Prajapati--

| 4 4 8
Pune, India
--Ghanshyam Prajapati--
OpenERP Developer
Ghanshyam Prajapati
On 3/21/14, 8:24 AM

Hi Sneha,

Try this,

from datetime import datetime
date_format = "%m/%d/%Y"
a = datetime.strptime('8/18/2008', date_format)
b = datetime.strptime('9/26/2008', date_format)
delta = b - a
print delta.days # that's it

See following link

Hope it works for you

Where to give this code?What if the date is not specified as 8/18/2008 and 9/26/2008

sneha antony
on 3/21/14, 8:54 AM

suppose your date format is '2014-12-31', for that your date_format will be '%Y-%m-%d'

Ghanshyam Prajapati
on 3/21/14, 9:34 AM

This is to be added in the .py file right?

sneha antony
on 3/24/14, 5:18 AM

Which names are to be given instead of 8/18/2008 and 9/26/2008 in my code?

sneha antony
on 3/24/14, 5:21 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 3/21/14, 7:59 AM
Seen: 2549 times
Last updated: 3/16/15, 8:10 AM