How to make a filter for the current and the last week?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

How to make a filter for the current and the last week?

filter current week today relativedelta

2 Odpowiedzi

14327 Widoki

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...)

Pascal Tremblay

Autor Najlepsza odpowiedź

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

Ricardo Gross

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, ...

Ricardo

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
filter on current week Rozwiązane filter week	4 sie 22	13099
"Today Activities" not filtering correctly filter today Activities	0 mar 24	1042
How to make a filter for the current and the last month? Rozwiązane filter current period last	2 wrz 24	27568
Differentiating subscription invoices from one-shot services Rozwiązane filter	3 wrz 25	256
How to filter contact those parent are in archive stage Rozwiązane filter	1 wrz 25	954

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!