Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi everyone,
I want to extract just the date from create_date field in the account.invoice model.
I tried t_date = datetime.datetime.strptime(record.create_date, '%Y-%m-%d') and bunch of other options but none worked.
Kindly help, it's for Odoo online Saas version, in particular to the automated actions.
If above answer give you error "ValueError: unconverted data remains" or doesn't work
Try:
from dateutil import parser
datetime_obj = parser.parse('2018-02-06T13:12:18.1278015Z')Hope it help.
Dear Shaheryar Rajper,
Try this:
from datetime import date, datetime,
t_date= datetime.strptime(record.create_date, "%Y-%m-%d %H:%M:%S").date()
I hope I helped You...
Hi Ayman,
I get this error "<class 'AttributeError'>: "module 'datetime' has no attribute 'strptime'" while evaluating"
then if I change it to t_date= datetime.datetime.strptime(record.create_date, "%Y-%m-%d %H:%M:%S").date() I get "Can't convert 'datetime.date' object to str implicitly" while evaluating
I am using Odoo Saas automated actions, date and datetime are available so I dont need to import
Edit:
The correct way of doing it is
t_date= datetime.datetime.strptime(record.create_date, "%Y-%m-%d %H:%M:%S").strftime('%Y-%m-%d')
hopefully it helps others as there is lack of Saas support
Make Print to ensure that is not null.
print " DDDDDDDDDD ", record.create_date
i cannot do a print so i added it to a raise Warning and it works :)
This is my code
t_date= datetime.datetime.strptime(record.create_date, "%Y-%m-%d %H:%M:%S").strftime('%Y-%m-%d')
if (t_date > record.date_invoice) :
raise Warning("Payment Date "+record.date_invoice+" cannot be before than the Donation Date"+" "+t_date)
أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!
تسجيل| المنشورات ذات الصلة | الردود | أدوات العرض | النشاط | |
|---|---|---|---|---|
|
2
يوليو 24
|
15147 | ||
|
0
فبراير 22
|
3103 | ||
|
1
يوليو 21
|
9283 | ||
|
0
أبريل 20
|
5692 | ||
|
1
مايو 18
|
4020 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Reference: https://learnopenerp.blogspot.com/2021/07/how-to-use-and-convert-date-field-format-odoo.html