Jiras task done last month

[Lucia Lara]

Hi there!

I want to report my task done every month, by filtering my issues and afterwards exporting as CSV file, but still I have problems on running the filter, it seems I need to change something (problably in the updated day) for indicate I want the last updated in the last month

Please have a look on the filter

assignee = currentUser() AND updated = endOfMonth(-1M)   AND resolution =  Done  order by updated DESC

Thanks in advance and best regards

[Thomas Schlegel · Accepted solution]

Hi @Lucia Lara 

try this:

assignee = currentUser() AND updated > endOfMonth(-1M) and resolution is not empty

[Dharma Ramos]

Hi Lucia, 

Did you mean for it to be a rolling list of everything (including previous months/years) prior to the end of the previous month? Or do you want it to only be for the previous month? If the latter, then you need something more like:

assignee = currentUser() and updated > startOfMonth(-1) and updated < endOfMonth(-1) and resolution is not empty