Odoo Help


Relative Date (today, this month, e.g.) in Filter

Robert Klüsener
on 5/22/13, 2:08 PM 13,276 views

How can I use a relative date like for example today for filtering?

I filtered all due / overdue invoices in the suppliers invoice list using the attribute "due date" "is less or equal than". As I want to create a template from this filter it should not refer to a concrete date like 22.05.2013 but to the relative date. So I could use the template every day without modification.

This question has been included in the official documentation.
On 4/2/15, 1:43 AM

Hi, To manage filters active mode developer *Activate the developer mode*. in displayed list choose Manage Filters and add your filter. in domain [['date_invoice','=',time.strftime('%Y-%m-%d')]] Thanks.

@Borni DHIFI, i am sorry. I tried to add your post for developer info using Promote to Doc. but instead clicked wrongly on Convert as a comment. I am very sorry.

Atchuthan - Technical Consultant, Sodexis Inc
on 4/2/15, 1:44 AM
This question has been included in the official documentation.
Ray Carnes
On 4/1/15, 10:27 PM

In version 8, you can now do this:


In version 9, you can use this as a filter:

<filter string="Today" domain="[('date_field_from_the_model_you_want_to_filter', '&gt;=', datetime.datetime.now().strftime('%Y-%m-%d 00:00:00')),('date_field_from_the_model_you_want_to_filter', '&lt;=',datetime.datetime.now().strftime('%Y-%m-%d 23:23:59'))]"/>

Is there a way to save the filter in that manner? I am looking for a way to save the relative filter for a report

Sophie Kowalski
on 3/8/16, 5:26 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/22/13, 2:08 PM
Seen: 13276 times
Last updated: 5/31/17, 4:36 AM