How can I filter all invoices that are due within the next 7 days? I tried the following code and it does not work out:
[['date_due', '<=', time.strftime('%Y-%m-%d %H:%M:%S',time.gmtime(time.time()+7243600))]]
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
1
Beantwoorden
4390
Weergaven
hi you should use context_today(), try somethink like:
['&',('date_due','<', ((context_today() + relativedelta(days=7)).strftime('%Y-%m-%d'))),('date_due','>', ((context_today()).strftime('%Y-%m-%d')))]
Unfortunately this does not work out.
['&',('date_due','<', ((context_today() + relativedelta(weeks=0,day=7, weekday=-1)).strftime('%Y-%m-%d'))),('date_due','>', ((context_today()).strftime('%Y-%m-%d')))]
Does show no invoice
[('date_due','<=', ((context_today() + relativedelta(weeks=0,day=7, weekday=-1)).strftime('%Y-%m-%d')))]
Does show only the invoices that are due before today but not the invoices which became due in the next 7 days.
- relativedelta(days=7) is correct, sorry
Thanks! I modified it a bit and this works:
[('date_due','<=', ((context_today() + relativedelta(days=7)).strftime('%Y-%m-%d')))]
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden| Gerelateerde posts | Antwoorden | Weergaven | Activiteit | |
|---|---|---|---|---|
|
|
0
jan. 17
|
3131 | ||
|
0
jul. 25
|
887 | ||
|
change between 2 Invoice formats
Opgelost
|
|
1
jul. 25
|
666 | |
|
2
jul. 25
|
778 | ||
|
1
jul. 25
|
1848 |
