Odoo Help

Welcome!

This community 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.

0

How to get month from date

By
John Doe
on 5/4/16, 8:41 AM 585 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!'))
1

Prakash Sharma

--Prakash Sharma--
815
| 2 1 4
Delhi, India
--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: 
datetime.datetime.strptime(
str(record.date_invoice), '%Y-%m-%d').month==month_number ) 

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

Hi John Doe, my explication in the question:

\https://www.odoo.com/es_ES/forum/ayuda-1/question/how-to-extract-month-from-date-invoice-in-python-101560#answer-101573

Anyway, Try this

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

For different formats

http://strftime.org/

I hope it helps you, regards.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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