How to get month from date

Question

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 · Accepted Answer

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  )

Jose Vasquez · Answer

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.

คำถามนี้ถูกตั้งค่าสถานะ

http://strftime.org/

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!