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
- Kirjanpito
- Varastointi
- PoS
- Project
- MRP
Tämä kysymys on merkitty
1
Vastaa
4401
Näkymät
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')))]
Nautitko keskustelusta? Älä vain lue, vaan osallistu!
Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!
Rekisteröidy| Aiheeseen liittyviä artikkeleita | Vastaukset | Näkymät | Toimenpide | |
|---|---|---|---|---|
|
|
0
tammik. 17
|
3141 | ||
|
1
elok. 25
|
100 | ||
|
0
heinäk. 25
|
931 | ||
|
change between 2 Invoice formats
Ratkaistu
|
|
1
heinäk. 25
|
713 | |
|
2
heinäk. 25
|
813 |
