how convert a datetime field and compare with current date?(odoo11)

filter date datetime

1 Svar

13404 Visninger

nasim

how convert a datetime field and compare with current date?

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?

....

thanks

Sehrish

Odoo Playing with Dates:

1- https://learnopenerp.blogspot.com/2016/09/how-to-convert-datetimedate-to.html

2- https://learnopenerp.blogspot.com/2018/02/python-strftime-datetime-formatting.html

3- https://learnopenerp.blogspot.com/2018/02/python-timedelta.html

4- https://learnopenerp.blogspot.com/2018/01/python-date-manipulation.html

Waleed Ali Mohsen

Bedste svar

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

Forfatter

Excellent

thanks so much for your help :)

Kan du lide at diskutere? Læs ikke bare med, deltag aktivt i debatten!

Opret en konto i dag for at få glæde af eksklusive funktioner, og bliv en del af vores skønne fællesskab!

Tilmeld dig

Relaterede indlæg	Besvarelser	Visninger
how get date from datetime field in domain of search view? Løst filter date search datetime	2 jan. 23	15866
How to filter for any day of the week in odoo filter date datetime odoo8.0	0 apr. 18	8123
How create filter for specific day based on field datetime? filter date datetime filters	0 mar. 15	7058
Need Studio compute code to show number of days from today vs. a date field Løst date datetime	2 jan. 24	4804
Adding days to a date date datetime	2 jun. 22	6993

Dette spørgsmål er blevet anmeldt

Kan du lide at diskutere? Læs ikke bare med, deltag aktivt i debatten!