How do I only capture items resolved in the last 30 days?

[Jeremy_Johnson]

How do I only capture items resolved in the last 30 days? I have tried using "AND resolved < startOfMonth(-1m)"  and it doesn't seem to work at all. Has anyone solved this problem?

[Ignacio Pulgar · Accepted solution]

Hi @Jeremy_Johnson,

Issues resolved within the last 30 days:

resolved > -30d

Issues resolved since the 00:00 hours of the first day of last month:

resolved > startOfMonth(-1)

Hope it helps.

[Jeremy_Johnson]

Thanks, this worked for me.

[Warren · Accepted solution]

Hi @Jeremy_Johnson 

You almost had it (change < to >), try

AND resolved > startOfMonth(-1m)

[Jeremy_Johnson]

Thanks!