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
filterdatedatetime
1 Odgovori
11977 Prikazi
Avatar
nasim

how convert a datetime field and compare with current date?

hi

I want to write a search view and define a filter in it, that compare "created_date" with "current date" and show all of requests that created today.

problem1: how write filter that get only date from "create_date" (because this field is datetime format)

problem2: how compare with current date?

<record id="support_services_view_search" model="ir.ui.view">

....

<filter name="today" string="Today" domain="[('??(how get date)???create_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 :)

Related Posts Odgovori Prikazi Aktivnost
how get date from datetime field in domain of search view? Solved
filter date search datetime
Avatar
Avatar
Avatar
2
jan. 23
14615
How to filter for any day of the week in odoo
filter date datetime odoo8.0
Avatar
0
apr. 18
6509
How create filter for specific day based on field datetime?
filter date datetime filters
Avatar
0
mar. 15
6021
Need Studio compute code to show number of days from today vs. a date field Solved
date datetime
Avatar
Avatar
2
jan. 24
3441
Adding days to a date
date datetime
Avatar
Avatar
Avatar
2
jun. 22
5456