Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
filterdatesearchdatetime
2 Odgovori
13721 Prikazi
Avatar
nasim

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
Opusti
Avatar
Waleed Ali Mohsen
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
Opusti
nasim
Avtor

Excellent

thanks so much for your help :)

Avatar
Calic Marko
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
Opusti
Related Posts Odgovori Prikazi Aktivnost
how convert a datetime field and compare with current date?(odoo11) Solved
filter date datetime
Avatar
Avatar
1
jan. 20
10914
How to filter by dates (date between two dates)
filter date search domain_filter
Avatar
Avatar
1
dec. 20
21176
search view date datetime Solved
date view search datetime
Avatar
Avatar
Avatar
Avatar
3
jan. 19
8266
Search within a period of date Solved
filter date v7 search
Avatar
Avatar
Avatar
Avatar
22
dec. 23
49371
How to filter for any day of the week in odoo
filter date datetime odoo8.0
Avatar
0
apr. 18
5553