Odoo Help


How to get month from date

John Doe
on 5/4/16, 8:41 AM 1,677 views

I d like to find a way to search invoices by a month taken from invoice number and ive got a problem with getting only a month from invoice date.

res = self.search([('type','=',inv_type),('date_invoice.!-month-!','=',number[5:7]),('date_invoice','>',date_invoice),('number','<',number), ('journal_id','=',journal)])
if res:
     raise except_orm(('Warning!'), ('Change date!'))

Prakash Sharma

--Prakash Sharma--
--Prakash Sharma--

I like to surround myself with brave, creative people.

My motivation for learning different technologies and algos drive me. I love challenges of a steep learning curve which I believe makes me a better learner. I have a strong desire to learn different technologies, which would enable me to become a full stack developer.

Prakash Sharma
On 5/4/16, 10:16 AM

search you data from the PostgreSQL using all domain expect   date_invoice   , after that you can use filtered  like:

import datetime

filtered(lambda record: 
str(record.date_invoice), '%Y-%m-%d').month==month_number ) 

Jose Vasquez
On 5/4/16, 3:12 PM

Hi John Doe, my explication in the question:


Anyway, Try this

import datetimemonth = datetime.strptime(your_date, '%Y-%m-%d').strftime('%m')

For different formats


I hope it helps you, regards.

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

1 follower(s)


Asked: 5/4/16, 8:41 AM
Seen: 1677 times
Last updated: 5/4/16, 3:12 PM