This question has been flagged
3 Replies
2389 Views

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:

  1. filter 'archived'

  2. in stage 'Finished'

  3. stage changed to 'Finished' after time 't' (e.g.) begin of last month

Thanks for any help in advance.

Avatar
Discard

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

Best Answer

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','&lt;=', (context_today()-relativedelta(day=31, months=1)).strftime('%Y-%m-%d')),

('date_from','&gt;=',(context_today()-relativedelta(day=1,months=1)).strftime('%Y-%m-%d'))]"

help="last month"/>

Avatar
Discard
Author Best Answer

Wow. Thank you for the quick reply.

That's a great idea. I will try that and get back to you.


Best,

Felix

Avatar
Discard