Odoo Help


Domain for display last 12 hours orders

Niraj Pajwani
on 5/17/16, 6:05 AM 714 views

I've created a domain for display last 12 hours orders, but it doesn't work correctly...

<field name="domain">[('create_date','&gt;=', (datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S'))),

('create_date','&lt;=', ((datetime.datetime.now()- datetime.timedelta(hours=12)).strftime('%Y-%m-%d %H:%M:%S'))) ]</field>

I am getting following error: Uncaught Error: TypeError: unsupported operand type(s) for -: 'datetime' and 'timedelta'.

Niraj Pajwani
on 5/17/16, 6:32 AM


Please write down your domain  as like below, it will work.

<field name="domain">[('create_date','&gt;=', (time.strftime('%%Y-%%m-%%d %%H:%%M:%%S'))),
('create_date','&lt;=', ((context_today() - datetime.timedelta(hours=12)).strftime('%%Y-%%m-%%d %%H:%%M:%%S'))) ]</field>

Please try with this and give your result. Hope it will work for you.

Thanks for your help... But still I am getting following error using this code: "Error: ValueError: No known conversion for %H"

Niraj Pajwani
on 5/21/16, 4:35 AM

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/17/16, 6:05 AM
Seen: 714 times
Last updated: 5/19/16, 12:57 AM