Odoo Help


How to group by day with a filter on datetime field

on 7/28/13, 2:13 PM 2,011 views

I would like to create a filter for grouping by day, the filter would be applied on 'datetime' field.

I have tried this:

<filter string="Day"
            ('timestamp','&lt;=', (time.strptime(timestamp,'%%Y-%%m-%%d %%H:%%M:%%S') + relativedelta(day=1)).strftime('%%Y-%%m-%%d %%H:%%M:%%S')),
             ('timestamp','>=', (time.strptime(timestamp,'%%Y-%%m-%%d %%H:%%M:%%S') - relativedelta(day=1)).strftime('%%Y-%%m-%%d %%H:%%M:%%S'))

But no positive result, I only get

TypeError: results.group_by is undefined

It loooks like 'timestamp' field does not get evaluated after comparison operator. Any ideas on how to implement this?

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

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

0 follower(s)


Asked: 7/28/13, 2:13 PM
Seen: 2011 times
Last updated: 3/16/15, 8:10 AM