Odoo Help


Prevent a user from selecting a future date using datepicker?

on 4/2/13, 5:40 PM 4,403 views

I would like to prevent a user from selecting a future date using the date picker. Is this possible? I am using version 6.0.4.

Mike Telahun
On 4/3/13, 3:29 AM

Yes, you can create your own module that:

  1. Adds an on_change attribute to the field in the view
  2. Creates a method that gets called by the on_change attribute in #1. The method returns False if the date chosen is greater than today.

For example, in your form view you would have:

<field name="my_date" on_change="onchange_date(my_date)"/>

Then in your object you would put:

from datetime import datetime
from openerp.tools import DEFAULT_SERVER_DATE_FORMAT

def onchange_date(self, cr, uid, ids, my_date, context=None):
    if datetime.strptime(my_date, DEFAULT_SERVER_DATE_FORMAT).date() > datetime.now().date():
        return False
    return my_date

Edit: add example of constraint mentioned by Priyesh:

A constraint has the added benefit that it doesn't depend on the client interface calling the on_change method. It always gets checked when a value is written to the field.

def _check_date(self, cr, uid, ids, context=None):
    obj = self.browse(cr, uid, ids[0], context=context)
    if datetime.strptime(obj.my_date, DEFAULT_SERVER_DATE_FORMAT).date() > datetime.now().date():
        return False
    return True

_constraints = [(_check_date, 'Date is in the future!', [my_date])]

Thanks a lot,,,

on 10/30/13, 1:50 AM

Priyesh Solanki (pso)

--Priyesh Solanki (pso)--

| 2 2 4
--Priyesh Solanki (pso)--
Priyesh Solanki (pso)
On 4/3/13, 4:09 AM

You can also create Openerp Constraint for this. It will trigger when you will try to save the record.

Thanks, Priyesh Solanki

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

2 follower(s)


Asked: 4/2/13, 5:40 PM
Seen: 4403 times
Last updated: 3/16/15, 8:10 AM