Odoo Help


How to use dynamic dates in my filters? e.g. deadline date = today in project tasks

Frédéric Gilson (fgi)
on 6/10/14, 10:28 AM 1,145 views


I would like to create a dynamic filter in order to easily retrieve tasks for which the deadline = today. Today is a dynamic value that changes everyday... So an advanced search is not really appropriated! How to set this?

It could be useful in lots of other contexts. In CRM for instance, retrieving all the opportunities for which the next action date = today would also useful!

This question has been included in the official documentation.

1. Create an advanced filter from the task interface (e.g. Deadline = 31/12/2014).

2. Go to Settings > Technical > User Interface > User-defined Filters, and open the one you just created.

3. Replace the applied filter by this one: [('date_deadline','=',time.strftime('%Y-%m-%d'))]

4. Now by using this filter in your tasks, you get in one click all the tasks that must be closed today! As easy as this!


You can also set up an advanced filter to get all the tasks that have to be executed this week (today + 5 days): [('date_deadline','>=',time.strftime('%Y-%m-%d')),('date_deadline','<=', (context_today() + datetime.timedelta(days=5)).strftime('%Y-%m-%d'))]

You can also go further by getting all the deadlines in the 5 coming days: [('date_deadline','>=',time.strftime('%Y-%m-%d')),('date_deadline','

Frédéric Gilson (fgi)
on 7/9/14, 4:19 AM
This question has been included in the official documentation.
On 7/9/14, 8:49 AM

how to check commitment date is greater than order date by 2 days,the problem am facing is commitment date and date order are datetime datatypes,give me a solution

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

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: 6/10/14, 10:28 AM
Seen: 1145 times
Last updated: 3/16/15, 8:10 AM