how get date from datetime field in domain of search view?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

All Posts People Badges

Tags (View all)

odoo v14 accounting v15 odoo16features

About this forum

Help

how get date from datetime field in domain of search view?

filter date search datetime

2 Replies

12102 Views

nasim

odoo11

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

how set " datetime_field" in below:

Thanks

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)))]" />

nasim

Author

Excellent

thanks so much for your help :)

Calic Marko

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')]"/>

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Related Posts	Replies	Views
how convert a datetime field and compare with current date?(odoo11) Solved filter date datetime	1 Jan 20	9455
How to filter by dates (date between two dates) filter date search domain_filter	1 Dec 20	19656
search view date datetime Solved date view search datetime	3 Jan 19	7455
Search within a period of date Solved filter date v7 search	22 Dec 23	47627
How to filter for any day of the week in odoo filter date datetime odoo8.0	0 Apr 18	4395

This question has been flagged

Enjoying the discussion? Don't just read, join in!