Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Dear all,
I am looking for a way to generate a list of all tasks that were concluded in the last month.
Any idea how to approach this?
I guess I need the following:
filter 'archived'
in stage 'Finished'
stage changed to 'Finished' after time 't' (e.g.) begin of last month
Thanks for any help in advance.
I think you cannot depend on last edit date.
Better add a date field and update that field based on onchange state.
Then you can easily filter by date.
<filter icon="terp-go-month" string="Last Month"
domain="[('date_from','<=', (context_today()-relativedelta(day=31, months=1)).strftime('%Y-%m-%d')),
('date_from','>=',(context_today()-relativedelta(day=1,months=1)).strftime('%Y-%m-%d'))]"
help="last month"/>
Wow. Thank you for the quick reply.
That's a great idea. I will try that and get back to you.
Best,
Felix
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
Dec 24
|
43 | ||
|
2
Nov 24
|
156 | ||
|
1
Oct 24
|
183 | ||
|
1
Jun 24
|
363 | ||
|
2
Jun 24
|
424 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Hi, have also a look at the module https://apps.odoo.com/apps/modules/12.0/total_notify/ - it let you conduct any sort of lists based on relative dates and send such lists regurarly