Odoo Help


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

Robert Klüsener
on 5/22/13, 2:08 PM 16,730 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.


--Borni DHIFI --
| 6 8 9
Tunis, Tunisia
--Borni DHIFI --

Techno Functional Consultant Odoo(OpenERP) 


Skype : dhifi.borni

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

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

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
This question has been included in the official documentation.
Philippe Thuaud
On 4/3/18, 8:08 AM


I am trying to do this but I am confused on how to do this filter.

I am in Odoo v10 

In the accounting application.

in the list of invoices, I would like to add in the filter option an option to filter on the invoices from the last 7 days.

from the last month

from the last quarter

from the last year.

I don't understand how to do it.

I  go to developer mode, then in the manage filter and create a new one.

I am trying with this folowing info:

Filter name= Today

Model= Invoice

Action is left blank

Domain= [['date_invoice','=',time.strftime('%Y-%m-%d')]]

Context left as default []

Sort left by defualt []

Default filter is off

User is me

Active is enable

But then when I go to the list of invoice, I don't see the today option in the default filter option.

What I am doing wrong?

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: 16730 times
Last updated: 4/3/18, 8:08 AM