Skip to main content

Manage all kind of date range

Project description

Mature License: LGPL-3 OCA/server-ux Translate me on Weblate Try me on Runbot

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

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

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.

    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

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 smashing 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

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page