Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hello,
I want to add a filter to the sales app that shows the sales orders so far in the current month (updated automatically). That way I can add it to a spreadsheet to make a custom dashboard.
However I have not been able to create a filter that filters the creation date for the current month automatically.
Can someone help?
Thanks
Hi
Try this code in search view of sale order
<filter string="Current Month" name="current_month" domain="[('create_date','<',(context_today()+relativedelta(months=1)).strftime('%%Y-%%m-01')), ('create_date','>=',time.strftime('%%Y-%%m-01'))]"/>
Regards
Can you send a screenshot of where to put this code?
Thanks!
If you don't want to edit the view, (in Odoo 17+) in the filter pop-up you can input the following
(you need developer mode on)
The code is
[("date_order", ">", datetime.datetime.combine(context_today(), datetime.time(6, 0, 0)).strftime("%Y-%m-01 %H:%M:%S"))]Create an account today to enjoy exclusive features and engage with our awesome community!
Înscrie-te| Related Posts | Răspunsuri | Vizualizări | Activitate | |
|---|---|---|---|---|
|
Sales Order Follow up
Rezolvat
|
|
2
sept. 23
|
2173 | |
|
1
feb. 24
|
1411 | ||
|
1
dec. 23
|
5048 | ||
|
3
aug. 25
|
2762 | ||
|
1
mai 25
|
2723 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
