Skip to Content
Menu
Dette spørgsmål er blevet anmeldt
2 Besvarelser
27492 Visninger

Helloooooooooooooooooooooooo there!

Admit that we are march 7th.

I want a filter who accepts only date of the current month and the last month.

So I want a filter who accepts date from february 1st to march 31th (but I won't have document dated after the march 7th).

Is my filter ok?

XML filter :

<filter string="Current and last months" name="currentandlastmonths" 
domain="[
('date','&gt;=',(context_today()-relativedelta(months=1)).strftime('%Y-%m-01')),
('date','&lt;',(context_today()+relativedelta(months=1)).strftime('%Y-%m-01'))

]" />


Edit #1

Interesting link to learn about this kind of filter. Many examples there :

http://odoobyriyasshon.blogspot.ca/2015/07/search-view-filters-in-odoo.html


Avatar
Kassér

You have to be careful though, because the link you provided will not take timezone into account.

Bedste svar

Please follow below code :


A - <filter string="Current Month" name="current_month" domain="[(‘create_date’,'&lt;',(context_today()+relativedelta(months=1)).strftime('%%Y-%%m-01')), (‘create_date’,'&gt;=',time.strftime('%%Y-%%m-01'))]"/>

<filter string="Prev Month" name="prev_month" domain="[(‘create_date,'&gt;=',(context_today()-relativedelta(months=1)).strftime('%%Y-%%m-01')),(‘create_date','&lt;',time.strftime('%%Y-%%m-01'))]"/>
Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
1
dec. 22
3785
2
sep. 19
14281
1
aug. 25
132
0
jul. 25
945
1
maj 25
1662