v 15.0 Third Party 9240
Download for v 15.0 Deploy on Odoo.sh
Odoo Online
On Premise
Lines of code 880
Technical Name date_range
Versions 17.0 12.0 11.0 9.0 10.0 14.0 15.0 16.0
You bought this module and need support? Click here!

Date Range

Mature License: AGPL-3 OCA/server-ux Translate me on Weblate Try me on Runboat

This module lets you define global date ranges that can be used to filter your values in tree views.

It also provides a mixin model for developers that extends the model’s search view so that date ranges can be search as any relational field.

Table of contents


The addon use the daterange method from postgres. This method is supported as of postgresql 9.2


For regular usage, see Usage below. This section is to clarify optional functionality to developers.

To configure a model to use the Many2one style search field, make the model inherit from date.range.search.mixin:

class AccountMove(models.Model):
    _name = "account.move"
    _inherit = ["account.move", "date.range.search.mixin"]

This will make a Period field show up in the search view:

Date range Many2one search field

By default, the mixin works on the date field. If you want the mixin to work on a field with a different name, you can set a property on your model:

_date_range_search_field = "invoice_date"


To configure this module, you need to:

  • Go to Settings > Technical > Date ranges > Date Range Types where you can create types of date ranges.

    Create a type of date range
  • Go to Settings > Technical > Date ranges > Date Ranges where you can create date ranges.

    Date range creation

    It’s also possible to launch a wizard from the ‘Generate Date Ranges’ menu.

    Date range wizard

    The wizard is useful to generate recurring periods. Set an end date or enter the number of ranges to create.

    Date range wizard result
  • Your date ranges are now available in the search filter for any date or datetime fields

    Date range types are proposed as a filter operator

    Date range type available as filter operator

    Once a type is selected, date ranges of this type are porposed as a filter value

    Date range as filter value

    And the dates specified into the date range are used to filter your result.

    Date range as filter result
  • You can configure date range types with default values for the generation wizard on the Generation tab. In the same tab you can also configure date range types for auto-generation. New ranges for types configured for this are generated by a scheduled task that runs daily.

    Configure a date range for auto-generaton

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.






This module is maintained by the OCA.

Odoo Community Association

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

Current maintainer:


This module is part of the OCA/server-ux project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
There are no ratings yet!
Rohana Balagalla
on 9/26/22, 3:36 AM


This module seems to be quite useful for our Odoo implementation. The screen shots given in configuration area of the module can't be visible (corrupted or broken). Can we have some more details on how to configure the module? A user manual or any similar document will be very useful.