Skip to Content
Menu
This question has been flagged

I'm trying to filter one2many records based on current date. This is my xml code

    <field name="record_ids" domain="[('end_date', '>', cur_date)]">

        <tree string="records_tree">

                <field name="record_id"/>

                <field name="record"/>

                <field name="start_date"/>

                <field name="end_date"/>

        </tree>

    </field>

cur_date is a functional field I added to get current date.

My problem is records are not filtered in the view. Also it doesn't show any error message

Avatar
Discard
Best Answer

You can get current date for your domain like this:

domain="[('end_date','&gt;',context_today().strftime('%%Y-%%m-%%d'))]" 

more examples: filter-by-date-of-today-with-a-delay

Avatar
Discard
Author

Hi. Thanks for the answer. I added this domain to view. Its still shows records without filtration

Related Posts Replies Views Activity
3
Jul 15
31648
0
Mar 15
2866
1
Jun 22
12027
1
Jun 22
4905
0
Oct 17
2742