Odoo Help

0

Domain for display last 12 hours orders

By
Niraj Pajwani
on 5/17/16, 6:05 AM 633 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
1

Hello,

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.

Register

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)

Stats

Asked: 5/17/16, 6:05 AM
Seen: 633 times
Last updated: 5/19/16, 12:57 AM