I would like to create a dynamic search filter that change depending on the current week. I was able to do this quite easily for 'day' but not for 'week'. Because PostgreSQL has a function called 'current_date' I was able to write the following to create a custom filter that changes based on the current day: ['follow_up_date', '=', current_date] Now, what I am trying to do is create a similar filter that is based on the current week.
Any help is much appreciated.
Hi Omar, Please take a look at the below links you may get an idea, http://help.openerp.com/question/20731/creating-this-week-or-today-7-days-filter/, http://help.openerp.com/question/8149/filter-by-date-of-today-with-a-delay