Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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!'))
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 )
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
I hope it helps you, regards.
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
