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
filtercurrentweektodayrelativedelta
2 Odgovori
14237 Prikazi
Avatar
Pascal Tremblay

Hello all,

I want to make a filter in a search view.

This filter must accept invoices when their date is in this the current week or the last week.

We consider that the week begins at monday. We consider that the week ends at sunday.

If we are at the beginning of the week actually, we don't go back for 14 days. Current week always begins to the last monday (or the actual monday if we already are monday) and last week always begin to the previous monday. (Do you understand what I mean? Not easy to write it in english...) 

Avatar
Opusti
Avatar
Pascal Tremblay
Avtor Best Answer

I propose this filter :

(monday is weekday 0. sunday is weekday 6)

<filter string="Current and last weeks" name="currentandlastlastweeks" domain="[
        ('date','&gt;=',(context_today()+relativedelta(weeks=-2,days=1,weekday=0)).strftime('%Y-%m-%d')),
        ('date','&lt;',(context_today()+relativedelta(weekday=6)).strftime('%Y-%m-%d'))
                    ]" help="Journal invoices of the current and the last weeks" />


Avatar
Opusti
Avatar
Ricardo Gross
Best Answer

Hi,

One way would be: Group By > Add Custom Group > "Accounting Date" , and then in Group By > Accounting Date you can select "Week" , and the invoices will be divided between Wxx, Wxy, ...

BR

Ricardo


Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
filter on current week Solved
filter week
Avatar
Avatar
Avatar
Avatar
Avatar
4
avg. 22
13005
"Today Activities" not filtering correctly
filter today Activities
Avatar
0
mar. 24
988
How to make a filter for the current and the last month? Solved
filter current period last
Avatar
Avatar
2
sep. 24
27443
Having to manually clear filters in Odoo version 18 on the webstore shop makes us lose customers
filter
Avatar
0
jul. 25
881
Filters in multiple companies Solved
filter
Avatar
Avatar
1
maj 25
1596