Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
filterdatedatetime
1 Odpowiedz
12000 Widoki
Awatar
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

Awatar
Odrzuć
Awatar
Waleed Ali Mohsen
Najlepsza odpowiedź

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

Awatar
Odrzuć
nasim
Autor

Excellent

thanks so much for your help :)

Powiązane posty Odpowiedzi Widoki Czynność
how get date from datetime field in domain of search view? Rozwiązane
filter date search datetime
Awatar
Awatar
Awatar
2
sty 23
14632
How to filter for any day of the week in odoo
filter date datetime odoo8.0
Awatar
0
kwi 18
6532
How create filter for specific day based on field datetime?
filter date datetime filters
Awatar
0
mar 15
6034
Need Studio compute code to show number of days from today vs. a date field Rozwiązane
date datetime
Awatar
Awatar
2
sty 24
3444
Adding days to a date
date datetime
Awatar
Awatar
Awatar
2
cze 22
5461