Skip to Content
Menu
This question has been flagged
2 Replies
1814 Views

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 

Avatar
Discard
Best Answer

Hi 

Try this code in search view of sale order 

   

<filter string="Current Month" name="current_month"

        domain="[('create_date','&lt;',(context_today()+relativedelta(months=1)).strftime('%%Y-%%m-01')),

        ('create_date','&gt;=',time.strftime('%%Y-%%m-01'))]"/>


Regards

Avatar
Discard
Author

Can you send a screenshot of where to put this code?

Thanks!

Best Answer

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"))]
Avatar
Discard
Related Posts Replies Views Activity
2
Sep 23
2053
1
Feb 24
1355
1
Dec 23
4931
3
Aug 25
2224
1
May 25
2505