This question has been flagged
2 Replies
10896 Views

Hi

odoo11

how get date from datetime field in domain of search view? (for compare with current_date)

how set " datetime_field" in below:

<filter name="today" string="Today" domain="[('datetime_field','=',current_date]"/>

Thanks


Avatar
Discard
Best Answer

Hi,

You can use the below:


<filter string="Today" domain="[('datetime_field', '&gt;=', datetime.datetime.combine(context_today(), datetime.time(0,0,0))),
('datetimefield', '&lt;=', datetime.datetime.combine(context_today(), datetime.time(23,59,59)))]" />


Avatar
Discard
Author

Excellent

thanks so much for your help :)

Best Answer
You can use this if you want to filter Datetime field just by date:


​<field name="min_date" widget="date" filter_domain="[('min_date','>=',self+' 00:00:00'),('min_date','<=',self+' 23:59:59')]"/>


Avatar
Discard